#
ConstantColumnValue

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(Value_Expression)

## Arguments

Value_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 (Issue cycle for Progress category).

CASE WHEN NOT IsEmpty([Measures].[Average Progress days]) THEN ConstantColumnValue(CatchException( Median(VisibleRowsSet(), [Measures].[Average Progress days]) )) END

See the report example **Control chart (Progress cycle) **in our demo account. The measure **Median Average Progress days** created with standard calculation Add calculated > Statistical > Median uses the formula above.

## See also

- Add standard calculations based on a selected measure
- Function ConstantValue()
- Function Cache()