Skip to content

Latest commit

 

History

History
36 lines (24 loc) · 1.31 KB

rollupaddissubtotal-function-dax.md

File metadata and controls

36 lines (24 loc) · 1.31 KB
Raw
description title
Learn more about: ROLLUPADDISSUBTOTAL
ROLLUPADDISSUBTOTAL function (DAX) | Microsoft Docs

ROLLUPADDISSUBTOTAL

[!INCLUDEapplies-to-measures-columns-tables]

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

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.