BLANK() in DAX

[smpa01]

Hello,

I need to feed this logic into a measure.

A	B	C	Is Exclude
blank	blank	blank	yes
blank	blank	0	yes
blank	0	blank	yes
blank	0	0	yes
0	blank	blank	yes
0	blank	0	yes
0	0	blank	yes
0	0	0	yes

E.g. if I feed the above in a measure it would look like below.

Exclude1 := SWITCH(TRUE(), 
                         [A]=BLANK()&&[B]=BLANK()&&[C]=BLANK(),"Exclude",
                         [A]=BLANK()&&[B]=BLANK()&&[C]=0,"Exclude",
                         ..............................................
                         ..............................................
                         [A]=0&&[B]=0&&[C]=0,"Exclude",
                        "Include")

Is it safe to assume that the measure below will produce exactly the same result as the one above

Exclude2 := SWITCH(TRUE(), 
                         [A]=BLANK()&&[B]=BLANK()&&[C]=BLANK(),"Exclude",
                         "Include")

I once read in one of Zubair's post @Zubair_Muhammad that DAX treats BLANK() as zero. If that is the case, can Exclude1 be optimized as Exclude2?

Thank you in advance.

[amitchandak · Accepted solution]

@smpa01 , March 2020 release support coalesce , you can do like

Switch(True()
coalesce([A],0) =0 && coalesce([B],0)=0 && coalesce([C],0) =0 , "Exclude",
"Include")

[smpa01]

@amitchandak  did not have time to test out....crazy week... will come back to you after testing.