Measure IF statement not working as expected

[dre_sch]

Hi, this is my first time posting an issue. I'm not a very experienced user with creating new measures in Power BI and have tried searching all the posts to help resolve my problem without any success.

I have a table where I have created measures already for how many days it takes to close a case. I am trying to create another measure with true or false to show whether it was closed within the specified timeframe. However it's returning false for all results.

It should be anything between 0 and 3 = true, blank or greater than 3 = false. I previously had the formula as <=3 and it seemed to work fine except blanks where showing as true.

[dre_sch]

Sorry, I refreshed again and I am getting the correct results expect thank anything with a blank value is coming up as true and I want this to be false.

[Jihwan_Kim · Accepted solution]

Hi,

Thank you for your message.

Please replace =0 with ==0

Zero is considered as blank as well, but if you only want to restrict to NUMBER ZERO only but not a Blank, then try writing ==0

Thanks.

[dre_sch]

Hi 

I tried using || instead of && and it just made all the values as true.

[Jihwan_Kim]

Hi,

Please try replacing all of && in your meausre with || 

=> instead of using AND function, please try using OR function. In this case, the measure contains more than 2 of OR condition, so please try using ||