ISBLANK Function (DAX)

How does the ISBLANK Function (DAX) work?

ISBLANK Function (DAX) checks if the value is null, and returns either TRUE or FALSE.

ISBLANK Formula Syntax

ISBLANK (<value>) 

How do you use the ISBLANK function?

ISBLANK returns true whenever its only argument is a blank expression.

Related Blog Posts

Related Support Forum Posts

How to apply an IF ISBLANK with Filter
Looking to exclude items with no total
Customers visited and not visited

Considerations when using the ISBLANK function

When you use BLANK in a comparison, the conversion to 0 or to an empty string results in a positive match with these values. For this reason, comparing an expression to blank requires a specific function, ISBLANK, which returns true whenever its only argument is a blank expression.

Related Video Tutorials

Using-LASTNONBLANK-in-Power-BI-DAX-Function-Deep-Dive
Understanding The Calculate

EDNA TV-Harvesting a slicer selection

Formula examples using the ISBLANK function

//Sales to Previous Year Ratio  
  
=IF( ISBLANK('CalculatedMeasures'[PreviousYearTotalSales])  
   , BLANK()  
   , ( 'CalculatedMeasures'[Total Sales]-'CalculatedMeasures'[PreviousYearTotalSales] )  
      /'CalculatedMeasures'[PreviousYearTotalSales])  

Related DAX Functions

Information Functions
BLANK
COUNTBLANK

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.