Calculates the value only once per report execution per each column and stores those values in the cache. It can be useful when each row of the same column should use the same result of the calculation.
Syntax
ConstantColumnValue(Expression)
Arguments
Expression | MDX expression that typically returns a measure, a tuple, or a string. |
|---|
Examples
Function ConstantColumnValue is used in default report calculations for the option Add calculated: Average, Median, Min, and Max, % of Total
The formula example below is the standard statistical Median calculation calculated for Average progress days.
CASE WHEN NOT IsEmpty([Measures].[Average Progress days]) THEN
ConstantColumnValue(CatchException(
Median(VisibleRowsSet(), [Measures].[Average Progress days])
))
END
See also
Function ConstantValue() works similarly. It is usable if the calculation should be calculated only once per report.
Function Cache()