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.
You can now right click column in query and "Replace errors"... for anyone looking for a solution 10.2022