ROLLUPISSUBTOTAL DAX Function (Table manipulation)
Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL.
Syntax
ROLLUPISSUBTOTAL ( [<GrandtotalFilter>], <GroupBy_ColumnName>, <IsSubtotal_ColumnName> [, [<GroupLevelFilter>] [, <GroupBy_ColumnName>, <IsSubtotal_ColumnName> [, [<GroupLevelFilter>] [, … ] ] ] ] )
| Parameter | Attributes | Description |
|---|---|---|
| GrandtotalFilter | Optional |
Filter to be applied to the grandtotal level. |
| GroupBy_ColumnName | Repeatable |
A column to be returned. |
| IsSubtotal_ColumnName | Repeatable |
An added IsSubtotal column. |
| GroupLevelFilter | Optional Repeatable |
Filter to be applied to the current level. |
Return values
The function does not return a value. It only marks a subset of columns to ADDMISSINGITEMS.
Remarks
The ROLLUPISSUBTOTAL function is used exclusively within ADDMISSINGITEMS.
Examples
-- ROLLUPISSUBTOTAL populates in ADDMISSINGITEMS the corresponding columns
-- created by ROLLUPADDISSUBTOTAL in SUMMARIZECOLUMNS.
EVALUATE
ADDMISSINGITEMS (
'Date'[Calendar Year],
'Date'[Calendar Year Month],
SUMMARIZECOLUMNS (
ROLLUPADDISSUBTOTAL (
'Date'[Calendar Year],
"IsYearTotal",
'Date'[Calendar Year Month],
"IsYearMonthTotal"
),
"Amt", [Sales Amount]
),
ROLLUPISSUBTOTAL (
'Date'[Calendar Year],
[IsYearTotal],
'Date'[Calendar Year Month],
[IsYearMonthTotal]
)
)
Related functions
Other related functions are:
Last update: Apr 11, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Imke Feldmann
Microsoft documentation: https://docs.microsoft.com/en-us/dax/rollupissubtotal-function-dax
2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies