There are three types of measures; they are:

1. Non- additive measures: These are the ones on which no aggregation function can be applied. Example: Ratio or Percentage Column.

2. Semi- additive measures: These are the ones on which some of the aggregation functions can be applied. Example: Account Balance or Fee Rate.

3. Additive measures: These are the ones on which all the aggregation functions can be applied. Example: Number of Units Purchased.

BY Best Interview Question ON 01 Jul 2020