ISSUBTOTAL DAX Function (Information) Not recommended
Returns TRUE if the current row contains a subtotal for a specified column and FALSE otherwise.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| ColumnName |
The column you want to test. |
Return values
Returns TRUE if the current row contains a subtotal for a specified column and FALSE otherwise.
Remarks
The ISSUBTOTAL function is used exclusively within SUMMARIZE.
It is suggested to use SUMMARIZECOLUMNS instead of SUMMARIZE to create reports with subtotals.
Examples
-- ISSUBTOTAL checks if the current row in SUMMARIZE is
-- a subtotal for a column used in a ROLLUP
--
-- It is superseded by SUMMARIZECOLUMNS that has the
-- option of ROLLUPADDISSUBTOTAL, combining both ROLLUP
-- and ISSUBTOTAL in the same function.
EVALUATE
CALCULATETABLE (
SUMMARIZE (
'Product',
ROLLUP ( 'Product'[Brand] ),
"IsSubtotal", ISSUBTOTAL ( 'Product'[Brand] ),
"Sales", [Sales Amount]
),
Product[Brand] IN { "Contoso", "A. Datum", "Proseware" }
)
| Brand | IsSubtotal | Sales |
|---|---|---|
| Contoso | false | 7,352,399.03 |
| A. Datum | false | 2,096,184.64 |
| Proseware | false | 2,546,144.16 |
| (Blank) | true | 11,994,727.82 |
Related functions
Other related functions are:
Last update: Oct 22, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/issubtotal-function-dax
