How does the ISEMPTY Function (DAX) work?

ISEMPTY Function (DAX) checks whether a table is empty.

ISEMPTY Formula Syntax

ISEMPTY (<table_expression>)

How do you use the ISEMPTY function?

ISEMPTY returns True if the table is empty (doesn’t have any rows), otherwise, False.

Related Blog Posts

Related Support Forum Posts

How to apply an IF ISBLANK with Filter
Grouping based on single record item
Identify all Blank rows

Considerations when using the ISEMPTY function

Syntax using ISBLANK is more readable, and it could also produce some benefit in the query plan. However, when the table is not empty, you are always counting all the rows of the table, even if this is not strictly required. Microsoft added a DAX function in SQL Server 2012 SP1 Cumulative Update 4, so any build of Analysis Services 2012 and Power Pivot for Excel 2010 higher than 11.00.3368 can use the ISEMPTY syntax. It is simpler, meaningful and also faster. If you use DAXMD (query DAX on a Multidimensional model) the performance improvement offered by ISEMPTY is very important, and you should avoid using any COUNTROWS version to check if a table is empty.

Unfortunately, ISEMPTY is not available in Excel 2013, so using it in an Excel 2010 data model in Power Pivot will break the calculation once you upgrade the workbook to Excel 2013.

Related Video Tutorials

Formula examples using the ISEMPTY function

ISEMPTY (
    CALCULATETABLE (
        'Internet Sales',
        'Product Category'[Product Category Name]
    )
)

Related DAX Functions

Related Course Modules

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.