ISSUBTOTAL

Updated on
Rick de Groot

ISSUBTOTAL is a DAX function that returns TRUE if the current row contains a subtotal for a specified column, and FALSE otherwise.

Syntax

ISSUBTOTAL( ColumnName )
Argument Properties Description
ColumnName The column you want to test.

Return Values

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.

Other functions related to ISSUBTOTAL are:

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

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