Types of measure

Type of measure
1.Additive measure: - Can be summed across all dimensions such as sales amount.
2.Semi-additive measure: - can be aggregated across all dimensions except Time such as Account and inventory balance. If we attempt to aggregate these measures across time then we will get the wrong value. Exp. Bank account has balance 400 in Jan and 600 in Feb.
3.Non-Additive measure: - can’t be meaningfully aggregated across any dimension, such as Rates and percentages. We can use MDX Expression to define how they aggregated.