ROLLUP

ROLLUP is a DAX function that identifies a subset of columns in the SUMMARIZE function to calculate subtotals.

Syntax

ROLLUP( [ GroupBy_ColumnName, ... ] )

Argument	Properties	Description
GroupBy_ColumnName	Repeatable	A column to be returned.

Return Values

This function does not return a value. It only specifies the set of columns to be subtotaled.

Remarks

This function can only be used within a SUMMARIZE expression.

See SUMMARIZE.

Related functions

Other functions related to ROLLUP are:

• ROLLUPADDISSUBTOTAL
• ROLLUPGROUP
• ROLLUPISSUBTOTAL

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/rollup-function-dax