Forum Discussion
Divide by Zero error
Hi, Here is my dax measure: AVG = CALCULATE(IF( OR(ABS([Sales]) = 0, ABS([Pounds]) = 0),0,DIVIDE([Sales],[Pounds))) I got correct answer for all columns but except one, it shows very small num...
for except this error you should use ROUND
AVG = var _sales=Round([Sales],2) var _pounds = Round([Pounds],2) var _result = CALCULATE(IF( OR(_sales = 0, _pounds = 0),0,DIVIDE(_sales,_pounds )) return _result
for except this error you should use ROUND
AVG =
var _sales=Round([Sales],2)
var _pounds = Round([Pounds],2)
var _result = CALCULATE(IF(
OR(_sales = 0, _pounds = 0),0,DIVIDE(_sales,_pounds ))
return _result
Thanks for the solution! I solved it
please mark this topic as solved 🙂