BLANK greater than an integer?

[PaulDBrown]

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?

[Anonymous]

What I really do not understand is how come this is not seen as a bug? A Zero/False() is a valid value and it is not the same as a BLANK/NULL as this means no value at all. Surely this is a bug!

[Anonymous · Accepted solution]

@PaulDBrown 

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!

[PaulDBrown]

@az38 @edhans @Anonymous 

Thanks everyone for looking into this. It makes sense (sort of... intuitively I assumed that a blank was a no-value) and goes to show that you learn new things every day. 

I solved it easily using an IF statement combined with ISBLANK.  

All the best toyou all!

[edhans]

Blank is generally equivalent to zero in DAX. See this excellent overview on Blanks by SQLBI.

[az38]

Hi @PaulDBrown 

I've got a false in my data model

what data type of column with blank values?

and measure