ISEMPTY Function (DAX)
|
Checks if a table is empty.
ISEMPTY(<table_expression>)
Parameters
| Term | Definition |
|---|---|
| table_expression | A 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’:
| 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
Community Additions
ADD
Show: