ISSUBTOTAL

Syntax

Enables the user to create another column, in the Summarize function, that returns True if the row contains sub-total values for the column given as argument to ISSUBTOTAL, otherwise returns False.

SUMMARIZE(<table>, <groupBy_columnName>[, <groupBy_columnName>]…[, ROLLUP(<groupBy_columnName>[,< groupBy_columnName>…])][, <name>, {<expression>|ISSUBTOTAL(<columnName>)}]…)

Tutorial with example

In todays video I will show you how to use the DAX function ISSUBTOTAL.

Download example files:

Download the pbix here.

Remarks

• ISSUBTOTAL can only be used in the expression part of a SUMMARIZE function.
• ISSUBTOTAL must be preceded by a matching name column.