Forum Discussion
BIuser45
3 years agoFrequent Visitor
DAX not working when evaluating = zero
I have a forumla like this: PER = IF([Expense]=0,BLANK(),[Profit-Expense Ratio %]), but it doesn't work. It stills returns the [Profit-Expense Ratio %]. The expense shows 0, but actually the number i...
mickey64
Super User
3 years agoPlease try this formula below.
PER = IF([Expense]>0,[Profit-Expense Ratio %])