Forum Discussion

jakobcf4's avatar
jakobcf4
Frequent Visitor
9 years ago
Solved

Handling infinity value

Hi, friends! Please, help me in my issue: I want to calculate the percent of fee in our company, but after calculation, I see only Infinity or Nan. Could you please, clarify the reasons for this pr...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    jakobcf4

    Thanks for sharing your pbix. I think I've found the reason. It is a calculated column in your case, and the field dz or grs both can be 0, so you always get 0 or infinity. In you case, instead of calculated column, create a measure instead.

    Measure = DIVIDE(sum(t3[dz]),sum(t3[grs]))

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago
jakobcf4 wrote:

Still, doesn't work.

 

 

 

 

 

 

jakobcf4

Is it possible to share the pbix file? You can mask sensitive data before sharing.

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    jakobcf4

    Thanks for sharing your pbix. I think I've found the reason. It is a calculated column in your case, and the field dz or grs both can be 0, so you always get 0 or infinity. In you case, instead of calculated column, create a measure instead.

    Measure = DIVIDE(sum(t3[dz]),sum(t3[grs]))