ISEMPTY DAX Function (Information)
Returns true if the specified table or table-expression is Empty.
Table or table-expression.
TRUE if the table is empty (has no rows), if else, FALSE.
-- ISEMPTY checks that a table contains no rows -- -- This example retrieves the products with sales in 2007 and -- no sales in 2008 by using ISEMPTY EVALUATE VAR ProductsSales = ADDCOLUMNS ( TOPN ( 10, VALUES ( 'Product'[Product Name] ) ), "HasSalesIn2007", NOT ISEMPTY ( CALCULATETABLE ( Sales, 'Date'[Calendar Year] = "CY 2007" ) ), "NoSalesIn2008", ISEMPTY ( CALCULATETABLE ( Sales, 'Date'[Calendar Year] = "CY 2008" ) ) ) VAR Result = FILTER ( ProductsSales, [NoSalesIn2008] = TRUE && [HasSalesIn2007] = TRUE ) RETURN Result
Learn more about ISEMPTY in the following articles:
Check Empty Table Condition with DAX
In DAX there are different ways to test whether a table is empty. This test can be used in complex DAX expressions and this short article briefly discuss what are the suggested approaches from a performance perspective. » Read more
Syncing slicers in Power BI
The June 2019 update of Power BI includes the ability to filter slicer items based on a measure. This article explains why this is an important feature that should replace bidirectional filters used for the same purpose. » Read more
Last update: Jun 6, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/isempty-function-dax