ISSUBTOTAL

Applies to: Calculated column Calculated table Measure Visual calculation

Creates another column in a SUMMARIZE expression that returns True if the row contains subtotal values for the column given as argument, otherwise returns False.

Syntax

ISSUBTOTAL()

With SUMMARIZE,

SUMMARIZE(, [, ]…[, ROLLUP([,< groupBy_columnName>…])][, , {|ISSUBTOTAL()}]…)

Parameters



Term
Definition




columnName
The name of any column in table of the SUMMARIZE function or any column in a related table to table.



Return value
A True value if the row contains a subtotal value for the column given as argument, otherwise returns False.
Remarks

This function can only be used in the expression of a SUMMARIZE function.

This function must be preceded by the name of the Boolean column.


Example
See SUMMARIZE.