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

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] )  

Related DAX Functions

Information Functions

Related Course Modules



Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide