Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure IF statement not working as expected

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 succes...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

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