ROLLUP

In SUMMARIZE, adds subtotal rows for the columns named.

Group: Table manipulation. Compatible with DAX.

Syntax

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

Returns

No value. It marks the grouping columns that SUMMARIZE adds subtotal rows for.

Remarks

• Put it among SUMMARIZE's grouping columns. With one column it adds a grand total row; with several the totals nest from the last column outwards: products within a category, then each category, then the grand total.
• On a subtotal row the rolled-up columns are blank, and the expressions are evaluated over the whole group. ISSUBTOTAL tells those rows apart.
• Grouping columns before the ROLLUP get no totals of their own: a ROLLUP of the product after the category gives a total per category but no grand total.
• It works only among SUMMARIZE's grouping columns. In SUMMARIZECOLUMNS, use ROLLUPADDISSUBTOTAL.
• The rows come in no set order: sort them with ORDER BY, an ISSUBTOTAL column first, to put the totals last.

Examples

A grand total

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

A total per category, no grand total

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

Two nested levels

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

Related functions

SUMMARIZE, ISSUBTOTAL, ROLLUPGROUP, ROLLUPADDISSUBTOTAL.

Last updated 3 November 2026 · OpenBI Studio 0.3.74