Forum Discussion
Infinity and Divide; and figuring out DAX
I am attempting to get 0 (zero) instead of an 2422361554944000 Any Idea on a function that would return a proper division when not Blank or zero? Current Measure * Accuracy % = IFERROR(DIVIDE(IF(...
Is there a reason you keep ignoring my suggestion to ROUND the denominator?
Well Alexis thank you very much that was the trick. I was stuck on infinity and / or why this large number when the denominator was really 0.00. But by adding the ROUND to both my measure producing this I now get the right results. Again thank you very much.
Yep. This issue is that it wasn't really zero, even if it logically should have been. Possibly a floating-point error.