Table of contents
TOC
Collapse the table of content
Expand the table of content

ISEMPTY Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

Checks if a table is empty.

Syntax

ISEMPTY(<table_expression>)  

Parameters

TermDefinition
table_expressionA 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’:

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

Return value: FALSE

© 2018 Microsoft