ROLLUPISSUBTOTAL DAX Function (Table manipulation)
Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL.
Syntax
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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | -- 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: Mar 4, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Imke Feldmann
Microsoft documentation: https://docs.microsoft.com/en-us/dax/rollupissubtotal-function-dax