⟩ Tell us what are the different types of measures?
We have three types of measures
☛ Non- additive measures
☛ Semi-additive measures
☛ Additive measures
Non-additive measures are the ones on top of which no aggregation function can be applied. For example, a ratio or a percentage column; a flag or an indicator column present in fact table holding values like Y/N, etc. is a non-additive measure.