ROLLUPISSUBTOTAL DAX Function (Table manipulation)

Syntax  |  Return values  |  Remarks  |  Examples  |  Related  

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.

» 2 related functions

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]     ) )

 Try it Copy

Related functions

Other related functions are:

• ADDMISSINGITEMS
• ROLLUPGROUP

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