ISEMPTY Function (DAX)

 
System_CAPS_ICON_note.jpg Note


This function is included in SQL Server 2016 Analysis Services (SSAS), Power Pivot in Excel 2016, and Power BI Desktop only. Information provided here is subject to change.

Checks if a table is empty.

ISEMPTY(<table_expression>)  

Parameters

TermDefinition
table_expressionA table reference or a DAX expression that returns a table.

True if the table is empty (has no rows), if else, False.

For the below table named ‘Info’:

CountryStateCountyTotal
INDJK20800
INDMH251000
INDWB10900
USACA5500
USAWA10900
EVALUATE   
ROW(“Any countries with count > 25?”, NOT(ISEMPTY(FILTER(Info, [Count]>25)))  

Return value: FALSE

Community Additions

ADD
Show: