Divide by Zero error

[Anonymous]

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 number(-6,219,471,085,398,656) after I using this measure, it should be showed as zero.

What is the issue with it?

[PaulDBrown]

Why the ABS?

if you want to check if the measure is 0 (not blank), use [Sales] == 0

[SolomonovAnton · Accepted solution]

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

[Anonymous]

Thanks for the solution! I solved it

[SolomonovAnton]

please mark this topic as solved 🙂

[SolomonovAnton]

hello 

it is mean what in [pounds] you have number 2.66E-14

another words it is not 0 it is very small number