Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Strange behavior with nested IF when using BLANK

Hi guys, 

 

I'm new to the communtity when it comes to asking questions but I found a bunch of insights here so I hope you can help me with this one 🙂

 

I'm having problems with Power BI behavior when using a nested IF function. You can see how the functions if defined, and trust me that I tried a bunch of different ways to approach the same problem. For some reason it reads the zero values as BLANKs and then the DAX function doesn't get applied the right way. Is this something that's native to DAX, that it doesn't support nested IF's as well as Excel? Based on this logic the "order in full" should return a 1 not a zero. If I use only one IF statement it works fine for all cases except when the "order in full" is BLANK, so I had to use the nested IF.

Is this error maybe caused by summarised table? 

 

Thank you guys in advance for your help 🙂

 

  • When using the = operator blank does equate to 0. To check for an actual blank value use ISBLANK() instead.

  • you can also use the == operator.
    0 = BLANK() is True
    0 == BLANK() is False

4 Replies

  • When using the = operator blank does equate to 0. To check for an actual blank value use ISBLANK() instead.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Awesome, thank you, that did the trick 😄 I love how this community is filled with awesome people willing to help out!

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion

    you can also use the == operator.
    0 = BLANK() is True
    0 == BLANK() is False

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you so much for your help 🙂 I feel stupid, I didn't think of it being so simple ğŸ˜…