How to Use ISBLANK in DAX in Power BI: Simple Guide
In Power BI, use the
ISBLANK function in DAX to check if a value or expression is empty (blank). It returns TRUE if the value is blank and FALSE otherwise, helping you handle missing data in your reports.Syntax
The ISBLANK function has a simple syntax with one argument:
ISBLANK(value): Checks if the value is blank.
If the value is blank or empty, it returns TRUE. Otherwise, it returns FALSE.
DAX
ISBLANK(<value>)
Example
This example shows how to create a measure that checks if the SalesAmount column is blank for each row and returns a text message accordingly.
DAX
Is Sales Blank = IF(ISBLANK(Sales[SalesAmount]), "No Sales", "Sales Recorded")
Output
For a row where SalesAmount is blank: "No Sales"
For a row where SalesAmount has a value: "Sales Recorded"
Common Pitfalls
One common mistake is confusing ISBLANK with checking for zero or empty strings. ISBLANK only returns TRUE for truly blank values, not zeros or empty text.
Also, using ISBLANK on calculated columns or measures that return zero or empty strings will return FALSE.
DAX
Wrong = ISBLANK(0) // Returns FALSE because 0 is not blank Right = ISBLANK(BLANK()) // Returns TRUE because BLANK() is truly blank
Quick Reference
| Function | Description | Returns |
|---|---|---|
| ISBLANK(value) | Checks if value is blank | TRUE if blank, otherwise FALSE |
| BLANK() | Returns a blank value | Blank |
| IF(condition, true_result, false_result) | Returns values based on condition | Depends on condition |
Key Takeaways
Use ISBLANK to detect empty or missing values in your data.
ISBLANK returns TRUE only for blank values, not zeros or empty text.
Combine ISBLANK with IF to create conditional logic in your reports.
BLANK() creates a blank value that ISBLANK can detect.
Check your data type because ISBLANK behaves differently on numbers and text.