What Is A Level-Based Measure?
A level-based measure is a column whose values are always calculated to a specific level of aggregation. Here is an example of a level-based measure using a Products and Revenue table. A level-based hierarchy is created for Products as follows:
By default, when we drill down within the products hierarchy from Brand level to Product level, the corresponding Revenue drills down to Product level.