Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayROLLUPADDISSUBTOTAL
Applies to: 
Calculated column
Calculated table
Measure 
Visual calculation
Modifies the behavior of the SUMMARIZECOLUMNS function by adding rollup/subtotal rows to the result based on the groupBy_columnName columns. This function can only be used within a SUMMARIZECOLUMNS expression.
DAX
ROLLUPADDISSUBTOTAL ( [<grandtotalFilter>], <groupBy_columnName>, <name> [, [<groupLevelFilter>] [, <groupBy_columnName>, <name> [, [<groupLevelFilter>] [, … ] ] ] ] )
| Term | Definition |
|---|---|
grandtotalFilter |
(Optional) Filter to be applied to the grandtotal level. |
groupBy_columnName |
Name of an existing column used to create summary groups based on the values found in it. Cannot be an expression. |
| name | Name of an ISSUBTOTAL column. The values of the column are calculated using the ISSUBTOTAL function. |
groupLevelFilter |
(Optional) Filter to be applied to the current level. |
The function does not return a value.
None
See SUMMARIZECOLUMNS.