Edit

Share via


ROLLUPADDISSUBTOTAL

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.

Syntax

DAX
ROLLUPADDISSUBTOTAL ( [<grandtotalFilter>], <groupBy_columnName>, <name> [, [<groupLevelFilter>] [, <groupBy_columnName>, <name> [, [<groupLevelFilter>] [, … ] ] ] ] )

Parameters

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.

Return value

The function does not return a value.

Remarks

None

Example

See SUMMARIZECOLUMNS.