ISBLANK
Whether a value is blank.
Group: Logical. Compatible with DAX.
Syntax
ISBLANK ( <value> )| Parameter | Type | Description |
|---|---|---|
value | Value | What to check for a blank: a column, a measure or any expression. |
Returns
Boolean. Whether the value is a blank: TRUE for a blank, FALSE for anything else.
Remarks
- 0 and empty text are values, not blanks.
- Adding 0 turns a blank into 0, so
ISBLANK ( BLANK () + 0 )is FALSE; multiplying keeps it blank. - A measure is blank where there are no rows for it, so
ISBLANK ( [Liters sold] )is TRUE for a product with no sales in the filter. - To treat a blank and a 0 alike, compare with
=: a blank equals 0 there.
Examples
What is blank
EVALUATE
ROW (
"Blank", ISBLANK ( BLANK () ),
"0", ISBLANK ( 0 ),
"Empty text", ISBLANK ( "" ),
"Blank + 0", ISBLANK ( BLANK () + 0 ),
"Blank * 1", ISBLANK ( BLANK () * 1 )
)| Blank | 0 | Empty text | Blank + 0 | Blank * 1 |
|---|---|---|---|---|
| TRUE | FALSE | FALSE | FALSE | TRUE |
Bonds without a price
EVALUATE
SELECTCOLUMNS ( FILTER ( Holdings, ISBLANK ( Holdings[Price] ) ), "Bond", Holdings[Bond] )
ORDER BY [Bond]| Bond |
|---|
| Covered 2029 |
| Municipal 2031 |
Related functions
BLANK, COALESCE, ISEMPTY, COUNTBLANK, IF.