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.
- ROLLUPGROUP can only be used in the expression part of a SUMMARIZE OR SUMMARIZECOLUMNS functions.
« Back to Index
Was this helpful?
Let us know your thoughts...