Explanation/Reference:
Note 1: A level-based measure is a column whose values are always calculated to a specific level of aggregation.
The calculation of this measure is independent of the query grain and used always the aggregation grain of the logical column.
Level-based measures allow :
* to return data at multiple levels of aggregation (the query grain and the level-based column grain) with one single query
* to create share measures (percentage), that are calculated by taking some measure and dividing it by a level-based measure. For example, you can divide salesperson revenue by regional revenue to calculate the share of the regional revenue each salesperson generates.
Note 2: To create a level based measure as the amount sold by region, you can:
* make a copy of the Amount Sold logical column
* and then
/drag the logical column into its hierarchy level
/or set the aggregation grain in the level tab of the logical column property.