Syntax
ROLLUPGROUP() can be used to calculate groups of subtotals. If used in-place of ROLLUP, ROLLUPGROUP will yield the same result by adding roll-up rows to the result on the groupBy_columnName columns. However, the addition of ROLLUPGROUP() inside a ROLLUP syntax can be used to prevent partial subtotals in roll-up rows.
Tutorial with example for SUMMARIZE
In todays video I will show you how to use the DAX function ROLLUPGROUP.

Tutorial with SUMMARIZECOLUMNS

Download example files:
Download the pbix here.
Remarks
- ROLLUPGROUP can only be used in the expression part of a SUMMARIZE OR SUMMARIZECOLUMNS functions.
Was this helpful?
Leave a Reply