# ISSUBTOTALDAX Function (Information) Not recommended

Returns TRUE if the current row contains a subtotal for a specified column and FALSE otherwise.

## Syntax

ISSUBTOTAL ( <ColumnName> )
Parameter Attributes Description
ColumnName

The column you want to test.

## Return values

Scalar A single boolean value.

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.

» 1 related function

## 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: Aug 3, 2024     » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation: https://docs.microsoft.com/en-us/dax/issubtotal-function-dax

# Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

# Row Context

This expression is executed in a Row Context. Click to read more.

# Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

# Not recommended

The use of this parameter is not recommended.

# Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

# Volatile

A volatile function may return a different result every time you call it, even if you provide the same arguments. Click to read more.

# Deprecated

This parameter is deprecated and its use is not recommended.

# DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

### Contribute

Want to improve the content of ISSUBTOTAL? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.