Forum Discussion
BIuser45
2 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
2 years agoSuper User
Please try this formula below.
PER = IF([Expense]>0,[Profit-Expense Ratio %])