Considering only non-blank measure in if condition

[Dunner2020]

Hi there,

I have a measure that compared four measures with numbers and produces the output in the form of "Yes" or "No". The measure looks like as follow:

final measure = 

IF([measure1] >= 4 && [measure2]>=10 && [measure3]>=14 && [measure4] >= 14,"Yes","No")

Now the issue is that not all 4 measures contain values at the same time. Either 2 or 3 measures have values and the remaining are blank. So I want to consider only those measures in if  condition that has values and ignores those who are blank. Is there any way of doing that in Power BI? 

[mahoneypat · Accepted solution]

Why not just add 0 to each measure so they are never blank, and they never satisfy their condition.

final measure = 

IF([measure1] +0>= 4 && [measure2]+0>=10 && [measure3]+0>=14 && [measure4] +0>= 14,"Yes","No")

Regards,

Pat

[Dunner2020]

@Anonymous , I already tried that and it did not work. Moreover, I want to setup blank measure in such away that if measure is blank then it should not be the part of if condition.

[Anonymous]

Hi @Dunner2020 - Can you try measure like below:

final measure = 

IF(NOT ISBLANK([measure1]) >= 4 && NOT ISBLANK([measure2])>=10 && NOT ISBLANK([measure3])>=14 && NOT ISBLANK([measure4]) >= 14,"Yes","No")

Thanks,

-Namish B