Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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(...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Is there a reason you keep ignoring my suggestion to ROUND the denominator?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you and yes I did do a test with just the numbers and not pulling from the dataset.  And yes it responds as you say.  However when using the dataset I get the infinity looking number as I have discribed.  I created two seperate measures: one for the Numerator and one for the denominator and both of those show 70500.00 & 0.00 respectively.  However if I use the

DIVIDE([*** Sal Inv Nt Wght], [*** Forecast Lbs],0) for example I get the 2422361554944000
If I use the two original measures formula 
DIVIDE([Sales Invoice Line Net Weight], [Forecast Lbs] ,0 ) I get 2422361554944000.  so regardless I get this large or infinity number instead of 0 (zero).  Any other thoughts?  I have tried this as a Measure and as a Calculated Column too.
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

Is there a reason you keep ignoring my suggestion to ROUND the denominator?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

    • AlexisOlson's avatar
      AlexisOlson
      Super User
      4 years ago

      Yep. This issue is that it wasn't really zero, even if it logically should have been. Possibly a floating-point error.