topic Re: Measure IF statement not working as expected in DAX Commands and Tips

Measure IF statement not working as expected

Anonymous — Fri, 22 Jul 2022 02:31:56 GMT

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.

Re: Measure IF statement not working as expected

Jihwan_Kim — Fri, 22 Jul 2022 02:39:47 GMT

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 ||

Re: Measure IF statement not working as expected

Anonymous — Fri, 22 Jul 2022 02:48:30 GMT

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

Re: Measure IF statement not working as expected

Anonymous — Fri, 22 Jul 2022 02:52:53 GMT

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.

Re: Measure IF statement not working as expected

Jihwan_Kim — Fri, 22 Jul 2022 03:09:05 GMT

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.