ROLLUP

Applies to: Calculated column Calculated table Measure Visual calculation

Modifies the behavior of the SUMMARIZE function by adding rollup rows to the result on columns defined by the groupBy_columnName parameter. This function can only be used within a SUMMARIZE expression.

Syntax

ROLLUP (  [,  [, … ] ] )

With SUMMARIZE,

SUMMARIZE(, [, ]…[, ROLLUP([,< groupBy_columnName>…])][, , ]…)

Parameters



Term
Definition




groupBy_columnName
The qualified name of an existing column or ROLLUPGROUP function to be used to create summary groups based on the values found in it. This parameter cannot be an expression.



Return value
This function does not return a value. It only specifies the set of columns to be subtotaled.
Remarks
This function can only be used within a SUMMARIZE expression.
Example
See SUMMARIZE.