GETMEASURECOLUMNS

The GETMEASURECOLUMNS function returns the list of columns at the given level of a specific measure. If a level is not provided, the leaf columns are returned. This function returns a range of values, and has to be to used with an aggregation function like SUM/AVG.

Syntax

GETMEASURECOLUMNS(measure, level)

Arguments

measure – The measure whose columns need to be returned. Required.

level – The level. Required. ******************************

Example

GETMEASURECOLUMNS([Sales], 1)