Checks whether a value is blank, and returns TRUE or FALSE.
The value you want to test.
A Boolean value of TRUE if the value is blank; otherwise FALSE.
The comparison with blank is also possible with the “strictly equal to” operator == as shown in the two following correspondent predicates.
ISBLANK ( <expression> ) -- same result as the following line <expression> == BLANK() -- same result as the previous line
Learn more about ISBLANK in the following articles:
How to handle BLANK in DAX measures
This article describes a counterintuitive behavior of BLANK in DAX measures affecting Power BI, Analysis Services, and Power Pivot. That behavior could cause mistakes in a report using alternate expressions of the same calculation. Indeed, these expressions are not equivalent when BLANK is involved. » Read more
Handling BLANK in DAX
The blank value in DAX is a special value requiring particular attention in comparisons. It is not like the special null value in SQL, and it could appear in any conversion from a table expression. This article explores in details the behavior of the blank value in DAX, highlighting a common error in DAX expressions […] » Read more
Check Empty Table Condition with DAX
In DAX there are different ways to test whether a table is empty. This test can be used in complex DAX expressions and this short article briefly discuss what are the suggested approaches from a performance perspective. » Read more
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/isblank-function-dax