Forum Discussion
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
- johnt75
Super User
When using the = operator blank does equate to 0. To check for an actual blank value use ISBLANK() instead.
- AnonymousNot applicable
Awesome, thank you, that did the trick 😄 I love how this community is filled with awesome people willing to help out!
- SpartaBI
Community Champion
you can also use the == operator.
0 = BLANK() is True
0 == BLANK() is False- AnonymousNot applicable
Thank you so much for your help 🙂 I feel stupid, I didn't think of it being so simple 😅