DAX Comparison operators

[Sweetie]

Hi, 

I am trying to compare a measure value with null("") through OR condition 

Ex:Measure = if(precreatedMeasure1 = "" || precreatedmeasure2 =0, "",sum(columndata)).

There is no error in syntax 

But doesn't support for visuals 

It says "DAX COMPARISON OPERATORS DO NOT SUPPORT COMPARING VALUES OF TYPE TEXT" 

(NULL is considered as text here )

can I please find any solution to compare with null values.

[Samarth_18]

Can you try below code

Measures =
IF (
OR ( precreatedMeasure1 = BLANK (), precreatedmeasure2 = 0 ),
BLANK (),
SUM ( columndata )
)

[Sweetie]

Hi @Samarth_18 ,

I was going through 

@https://youtu.be/C26DQkb4hy where in got to know Blank( ) and Null aren't same! 

So do we have any possibilities to compare a value with null.

If we have such It would be really helpful.

[Samarth_18 · Accepted solution]

DAX uses BLANK() for database nulls.

You can try above code it will resolve your issue and you can also refer below article.

https://docs.microsoft.com/en-us/dax/blank-function-dax

[Sweetie]

Hi @Samarth_18 ,

Thanks for your reply, I could understand now that Blank( ) and null aren't same but DAX treats them as same. 

And yes, DAX COMPARISON OPERATORS works fine when comparing with Blank( ).