ROLLUPGROUP

In ROLLUP or ROLLUPADDISSUBTOTAL, columns rolled up together as one level.

Group: Table manipulation. Compatible with DAX.

Syntax

ROLLUPGROUP ( <groupBy_columnName> [, <groupBy_columnName>] … )

Returns

No value. It marks columns that ROLLUP or ROLLUPADDISSUBTOTAL subtotal as a single level.

Remarks

• Columns in one ROLLUPGROUP get no subtotal between them: rolling up the category and the product together gives the product rows and a grand total, but no total per category.
• Use it inside ROLLUP (in SUMMARIZE) or ROLLUPADDISSUBTOTAL (in SUMMARIZECOLUMNS).

Examples

One level in SUMMARIZE

EVALUATE
SUMMARIZE (
    Sales,
    ROLLUP ( ROLLUPGROUP ( Products[Category], Products[Product] ) ),
    "Liters", SUM ( Sales[Liters] ),
    "Total", ISSUBTOTAL ( Products[Category] )
)
ORDER BY [Total], Products[Category], Products[Product]

One level in SUMMARIZECOLUMNS

EVALUATE
SUMMARIZECOLUMNS (
    ROLLUPADDISSUBTOTAL ( ROLLUPGROUP ( Products[Category], Products[Product] ), "Total" ),
    "Liters", [Liters sold]
)
ORDER BY [Total], Products[Category], Products[Product]

Related functions

ROLLUP, ROLLUPADDISSUBTOTAL, SUMMARIZE, SUMMARIZECOLUMNS.

Last updated 3 November 2026 · OpenBI Studio 0.3.74