Forum Discussion
Solved
division by zero
Hello, I have encountered problem, that is killing me. I need to use Direct Query mode, which does not support IFERROR function. I have several measures, that sometimes return error. For ...
KamilaOlek you can turn on feture to allow unrestricted measures in directquery which should then be able to use IFERROR function. You can go to File -> Options and settings -> DirectQuery.
What about just a simple IF statement?
=IF([QuantityKG] = 0,0,DIVIDE([NetValue],[QuantityKG])
You can also use DIVIDE function, probably a little cleaner:
=DIVIDE([NetValue],[QuantityKG],0)
DIVIDE will return the 3rd parameter as the value if a divide by zero occurs.
What about just a simple IF statement?
=IF([QuantityKG] = 0,0,DIVIDE([NetValue],[QuantityKG])
You can also use DIVIDE function, probably a little cleaner:
=DIVIDE([NetValue],[QuantityKG],0)
DIVIDE will return the 3rd parameter as the value if a divide by zero occurs.
I like your suggestion how to handle division by zero. I created this measure but need to change it to only calculate when a specific value is met.
% Driving Hrs = DIVIDE(sum(DriverLogs[driving_hrs]), sum(DriverLogs[eleven_hr_rule]) + sum(DriverLogs[driving_hrs]),0)
I need to figure out how to create this measure to only calculate when DriversLogs[Off Duty Hrs] < 24. suggestion? Thanks