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 problem?

Thank you in advance!

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]))

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Are you not using the DIVIDE() function?

    • jakobcf4's avatar
      jakobcf4
      Frequent Visitor
      9 years ago

      Hi!

       

      When I use this function,  I see only "0" in results.

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

        Hi!

         

        When I use this function,  I see only "0" in results.

        jakobcf4

        To have a better understanding on your scenario, could you give more specific details, such as sample data and measure dax?