Unexpected Infinity

Hi Anonymous , 

Use divide to avoid divide by 0. The reason why infinity is shown is that there are some values that are 0. 0 divided by a number is infinity. You can use the divide function to avoid infinity because the function can get 0 when it encounters a value of 0. Or you can make a conditional judgment, for example a/b, if a is 0 then get 0, otherwise a/b.

I cannot reproduce your issue. 

Please try to create a measure.

IFERROR(
   SUM('Detailed Data Set'[Total Hours]) / SUM('Detailed Data Set'[Norm Hours]),
    BLANK()
    )

If I have misunderstood your meaning, please provide some sample data and desired output.

I have alse found a similar post, please refer to it to see if it helps you.

Infinity error 

• If infinity error then use divide

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.