With Fixed, all the Dimensions that you want to include in the level of detail must be specified. So, if you want to exclude an existing Dimension, don't specify it, and if you want to include one, specify it. Here's how to rewrite the two previous LOD calculations with Fixed:
- { EXCLUDE [Sub-Category]: MAX([Sales]) } is equivalent to { FIXED [Category] : MAX([Sales]) } in the previous example. If you want to remove the Sub-Category, you don't specify it.
- AVG( { INCLUDE [Segment]: MAX([Sales]) } ) is equivalent to AVG( { FIXED [Category],[Sub-Category],[Segment]: MAX([Sales]) } ) in the previous example. If you want to add the Segment, you have to add all the existing Dimensions, plus the Segment.
Calculated Fields that use a Fixed ...
