A FIXED LOD expression computes a value using specified dimensions, without reference to the dimensions in the view. It locks the calculation to a specific granularity. The Core Syntax FIXED [Dimension 1], [Dimension 2] : SUM([Measure]) Use code with caution. Enclose the entire LOD expression. Keyword FIXED : Signals the type of LOD calculation. Dimensions: The specific attributes you want to group by. Colon : : Separates the dimensions from the aggregation.
A FIXED LOD expression computes a value using specified dimensions, without reference to the dimensions in the view. It locks the calculation to a specific granularity. The Core Syntax FIXED [Dimension 1], [Dimension 2] : SUM([Measure]) Use code with caution. Enclose the entire LOD expression. Keyword FIXED : Signals the type of LOD calculation. Dimensions: The specific attributes you want to group by. Colon : : Separates the dimensions from the aggregation.