As you know, each Dimension in the View splits the number of Marks and defines the level of detail for the Measure. However, at some point, you will probably need to aggregate a Measure at a different level than the View. To do that, you can use one of the three LOD functions. The three LODs are Include, Exclude, and Fixed:
- Include adds the specified Dimensions to the level of detail of an aggregated Measure. For example, the calculation { INCLUDE [Region]: SUM([Sales])} computes the sum of the sales by Region and all the other Dimensions in the View.
- Exclude removes the specified Dimensions from the level of detail of an aggregated Measure. For example, the calculation { EXCLUDE [Region]: SUM([Sales])} computes the sum ...