Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to clear off Infinity and NaN value?

Hi. I wanted to create another column based on this column.   I understand that NaN & infinity is because my calculations are when 0 divided by value, if I'm not mistaken, right? So what ...
Need Help
Show and Tell
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hey, @zhrhr

You can try to modify the measures as follows. The pbix file is attached at the end.

Minus MED TRIP IN = 
SUMX(
    Sheet1,
    DIVIDE(
       DIVIDE(Sheet1[sect_top],3.28084,0),
       Sheet1[TRIP IN SPEED BELOW MED]
    ) - 
    DIVIDE(
        DIVIDE(Sheet1[sect_top],3.28084,0),
        Sheet1[median]
    )
) + 0
LOSS wrt MED (TRIP IN) = ABS(SUMX(Sheet1,DIVIDE(Sheet1[Minus MED TRIP IN],24,0)*(Sheet1[Cost]*1000))) + 0

Result:

b1.png

Best regards

Allan

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