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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    Jihwan_Kim
    Super User
    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.