ISEMPTY

Checks if a table is empty.

Syntax

ISEMPTY(<table_expression>)  

Parameters

Term Definition
table_expression A table reference or a DAX expression that returns a table.

Return value

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

Example

For the below table named ‘Info’:

Country State County Total
IND JK 20 800
IND MH 25 1000
IND WB 10 900
USA CA 5 500
USA WA 10 900
EVALUATE   
ROW(“Any countries with count > 25?”, NOT(ISEMPTY(FILTER(Info, [Count]>25)))  

Return value: FALSE