Data Architect Interview Question:

Tell us what are the different types of measures?

Submitted by: Muhammad

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.
Submitted by: Muhammad