Forum Discussion
IF statement for value 0
I need to be able to differentiate 0 vs blank values in a DAX formula.
I've tried using ==0 for the number 0 and ="" for blanks, but == seems so be giving error in my DAX formula. How do I make this work? Attached a simplified dummy file, but with the same problem scenario.
DAX that gives no errors:
=IF(C5=0, "order more", IF(C5 ="", "unavailable", "OK"))
What I would like to do but can't get to work:
=IF(C5==0, "order more", IF(C5 ="", "unavailable", "OK"))
"==" is not supported in Excel. How to handle blanks is here Handling BLANK in DAX - SQLBI
Back to your case. BLANK()=0 returns TRUE, but ISBLANK(0) returns FALSE. Thus formula could be
Please check in attached file.
3 Replies
"==" is not supported in Excel. How to handle blanks is here Handling BLANK in DAX - SQLBI
Back to your case. BLANK()=0 returns TRUE, but ISBLANK(0) returns FALSE. Thus formula could be
Please check in attached file.
- Thank you. Is there some similar solution if I want to exclude value 0 but keep blanks with an advanced filter.
I've tried amount: <>"0"
