January 30, 2026 - -- 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, ...

January 16, 2025 - Its syntax is simple and effective: ISEMPTY(<table>). When applied, if the chosen table is empty, as determined by dax isempty, the function returns TRUE; conversely, it returns FALSE when information is present.

ISEMPTY: Returns true if the specified table or table-expression is Empty. https://dax.guide/isempty/

August 19, 2019 - Solved: Hi, I am using below DAX Return Type = var vTxt = IF(ISEMPTY(CALCULATETABLE(SAVO_QBR_TEMP, SAVO_QBR_TEMP[Return_Type] BLANK()))=False,

January 7, 2026 - It is commonly used to detect missing data in columns, handle empty measure results, or control calculations when a value is not available. ISEMPTY(), on the other hand, is used to check whether a table or table expression has any rows.

June 21, 2022 - ISEMPTY(<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.

May 1, 2017 - Explore the DAX ISEMPTY function to check for empty values in your data models. Understand its syntax and usage.

August 17, 2020 - ISEMPTY ( CALCULATETABLE ( 'Internet Sales', 'Product Category'[Product Category Name] ) ) This syntax is simpler, meaningful and also faster. If you use DAXMD (query DAX on a Multidimensional model) the performance improvement offered by ISEMPTY is very important, and you should avoid using any COUNTROWS version to check if a table is empty.

January 2, 2019 - The ISEMPTY function checks if a table is empty, returning the logical value True if it is positive (if it is empty) and the logical value False if it is not.

June 22, 2022 - To learn more about best practices when working with BLANKS, see Avoid converting BLANKs to values in DAX.

October 20, 2021 - Hi, I have 3 columns with different dates. I need a function that: IF Column Date1 is empty, take Column Date2, and if this one is empty, take Column Date3. If i use Column(Date1)="", it says DAX comparison cant compare Date with Text, the same happen when I use 0 or null. P.D: Maybe this...

October 19, 2022 - ISBLANK() refers to scalar values (individual cells). ISEMPTY() refers to tables. In DAX "everything is a table" - some just happen to be single column single row tables.

February 22, 2023 - Quickly search for answers, join discussions, post questions, and work smarter in your business applications by joining the Microsoft Dynamics 365 Community.

August 28, 2021 - All, I was recently working with @The_Bishop on a set of complex conditional formatting measures, and ran into a situation where we were getting some very unexpected results that after substantial effort traced back to the difference in how the DAX BLANK vs. ISBLANK functions treat zeros and blank/null values.

July 21, 2022 - Some useful info here: https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-isblank-isempty