Forum Discussion
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 ...
PhilipTreacy
Super User
Super UserHi Anonymous
Download your PBIX file with solution
This measure still had some division but wasn't using DIVIDE
Minus MED TRIP IN = SUMX(Sheet1, DIVIDE(DIVIDE(Sheet1[sect_top],3.28084,0),Sheet1[TRIP IN SPEED BELOW MED],0) - DIVIDE(DIVIDE(Sheet1[sect_top],3.28084,0),Sheet1[median],0)) + 0
Regards
Phil