ROLLUPISSUBTOTAL

Updated on

ROLLUPISSUBTOTAL is a DAX function that pairs up rollup groups with columns added by ROLLUPADDISSUBTOTAL.

Syntax

ROLLUPISSUBTOTAL(
   GrandtotalFilter,
   [ GroupBy_ColumnName, ... ],
   [ IsSubtotal_ColumnName, ... ],
   [ GroupLevelFilter, ... ]
)
Argument Properties 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

None

Remarks

This function can only be used within an ADDMISSINGITEMS expression.

Empty

Other functions related to ROLLUPISSUBTOTAL are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/rollupissubtotal-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy