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.
Was this helpful?
Leave a Reply