ISEMPTY - DAX Guide

ISEMPTY: Returns true if the specified table or table-expression is Empty.

This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.


#dax #powerbi #ssas #tabular #analysisservices #powerpivot

[rauljimenez]

Listening to you explanation on the logic of why you do something (e.g. at the end when you explain why ISEMPTY is better than COUNTROWS) has really helped my improve the performance of my DAX. Thank you for the great content you guys constantly share with us!!!

[eagillum]

I am trying to return a certain default image if a neighborhood is selected in the bar chart filter, but I don't have a corresponding picture for the city that the neighborhood is in (I have a key that corresponds cities and all the neighborhoods that are in them). I have tried IF(NOT(HASONEVALUE), IF(ISEMPTY(VALUES)), and IF(COUNTROWS)=0 and nothing works. I don't know what else to try. My Neighborhood-City Key and my Image Table is "many to many" (because my Image Table is concatenated Base 64 rows)- could that affect my code at all? I don't see how it could because when I filter my neighborhood table, there should literally be no city rows to show if I don't have a corresponding city listed in my Image Table.

[sbn]

It’s good, MrAlberto where get guides about using dax studio? Thank you

[gondebas]

Hello, I often see in dax code condition containing ISBLANK(Measure). Wouldn't checking ISEMPTY(Table) be faster than checking the measure build on that table? If we can solve the problem both ways, is there any preference?