ISBLANK DAX Function (Information)
Checks whether a value is blank, and returns TRUE or FALSE.
Syntax
Parameter | Attributes | Description |
---|---|---|
Value |
The value you want to test. |
Return values
A Boolean value of TRUE if the value is blank; otherwise FALSE.
Remarks
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
» 2 related functions
Examples
-- ISBLANK check that an expression is strictly equal to BLANK -- ISBLANK (x) is an alias for x == BLANK () -- An empty string and 0 are not considered blank by ISBLANK DEFINE VAR BlankValue = BLANK() VAR NumericValue = 42 VAR ZeroValue = 0 VAR EmptyString = "" EVALUATE { ( 1, "ISBLANK ( BlankValue )", ISBLANK ( BlankValue ) ), ( 2, "ISBLANK ( NumericValue )", ISBLANK ( NumericValue ) ), ( 3, "ISBLANK ( ZeroValue )", ISBLANK ( ZeroValue ) ), ( 4, "ISBLANK ( EmptyString )", ISBLANK ( EmptyString ) ), ( 5, "EmptyString == BLANK()", EmptyString == BLANK() ), ( 6, "EmptyString = BLANK()", EmptyString = BLANK() ) } ORDER BY [Value1]
Value1 | Value2 | Value3 |
---|---|---|
1 | ISBLANK ( BlankValue ) | true |
2 | ISBLANK ( NumericValue ) | false |
3 | ISBLANK ( ZeroValue ) | false |
4 | ISBLANK ( EmptyString ) | false |
5 | EmptyString == BLANK() | false |
6 | EmptyString = BLANK() | true |
-- ISBLANK cannot be used with tables, it requires a scalar value -- using it with tables forces the implicit conversion of a table -- to a scalar value and might result in an error DEFINE VAR EmptySet = FILTER ( { 1 }, FALSE ) VAR SetWithBlank = { BLANK() } EVALUATE { ( 1, "ISBLANK ( EmptySet )", ISBLANK ( EmptySet ) ), ( 2, "ISBLANK ( SetWithBlank )", ISBLANK ( SetWithBlank ) ) } ORDER BY [Value1]
Value1 | Value2 | Value3 |
---|---|---|
1 | ISBLANK ( EmptySet ) | true |
2 | ISBLANK ( SetWithBlank ) | true |
-- ISBLANK check that an expression is strictly equal to BLANK -- ISBLANK (x) is an alias for x == BLANK () DEFINE MEASURE Customer[EmptyNames] = -- Returns blanks and empty string CALCULATE ( COUNTROWS ( Customer ), Customer[Customer Name] = BLANK () ) MEASURE Customer[BlankNames] = -- Returns only blanks, same as == BLANK() CALCULATE ( COUNTROWS ( Customer ), ISBLANK ( Customer[Customer Name] ) ) EVALUATE SUMMARIZECOLUMNS ( Customer[Continent], "Customers", COUNTROWS ( Customer ), "Customers with empty name", [EmptyNames], "Customers with blank name", [BlankNames] )
Continent | Customers | Customers with empty name | Customers with blank name |
---|---|---|---|
Asia | 3,658 | 67 | 34 |
North America | 9,665 | 276 | 138 |
Europe | 5,546 | 42 | 21 |
Related articles
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
-
Hiding future dates for calculations in DAX
This article describes how to write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates. » Read more
-
Optimizing conditions involving blank values in DAX
This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases. » Read more
-
From SQL to DAX: Implementing NULLIF and COALESCE in DAX
This article describes how to implement a syntax equivalent to the T-SQL function NULLIF and the ANSI SQL function COALESCE, in DAX. » Read more
-
The COALESCE function in DAX
COALESCE is a DAX function introduced in March 2020. This article describes the purpose of COALESCE and how to simplify DAX expressions by removing verbose conditions, and yet obtain the same result. » Read more
-
Preparing a data model for Sankey Charts in Power BI
This article describes how to correctly shape a data model and prepare data to use a Sankey Chart as a funnel, considering events related to a customer (contact, trial, subscription, renewal, and others). » Read more
Related functions
Other related functions are:
Last update: Nov 7, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/isblank-function-dax