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.
Related functions
Other related functions are:
Last update: Jan 23, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Imke Feldmann
2018-2021 © SQLBI. All rights are reserved. Information coming from MSDN is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies