Forum Discussion
BLANK greater than an integer?
Hi all,
Can anyone confirm that a BLANK value is computed as greater than a value?
I have a measure which compares two values, to be used in conditional formatting. My surprise arises when I see that a blank value returns TRUE when it is compared to a value (positive in my case, but I don't see why it should make a difference; a blank is a blank, isn't it?).
What's the logic?
In Dax Blank equivalent to Zero only when the data type is Numbers.
For other data types(Date, Text), a blank is just a blank.
Paul Zheng
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!
5 Replies
Hi PaulDBrown
I've got a false in my data model
what data type of column with blank values?
and measure
Blank is generally equivalent to zero in DAX. See this excellent overview on Blanks by SQLBI.
In Dax Blank equivalent to Zero only when the data type is Numbers.
For other data types(Date, Text), a blank is just a blank.
Paul Zheng
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!
