ISEMPTY is a DAX function that returns TRUE if the specified table or table-expression is empty.
Syntax
ISEMPTY( Table )| Argument | Properties | Description |
|---|---|---|
| Table | Table or table-expression. |
ISEMPTY
Updated on
ISEMPTY is a DAX function that returns TRUE if the specified table or table-expression is empty.
ISEMPTY( Table )| Argument | Properties | Description |
|---|---|---|
| Table | Table or table-expression. |
True if the table is empty (has no rows), if else, False.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
For the below table named ‘Info’:
| Country/Region | 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, [County]>25))))
Return value: `FALSE“
Other functions related to ISEMPTY are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy