ROLLUP

Syntax

The addition of the ROLLUP() syntax modifies the behavior of the SUMMARIZE function by adding roll-up rows to the result on the groupBy_columnName columns.

SUMMARIZE(<table>, <groupBy_columnName>[, <groupBy_columnName>]…[, ROLLUP(<groupBy_columnName>[,< groupBy_columnName>…])][, <name>, <expression>]…)

Tutorial with example

In todays video I will show you how to use the DAX function ROLLUP:

Download example files:

Download the pbix here.

Remarks

• ROLLUP can only be used in the expression part of a SUMMARIZE function.
• The columns mentioned in the ROLLUP expression cannot be referenced as part of a groupBy_columnName columns.