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

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?

      • jakobcf4's avatar
        jakobcf4
        Frequent Visitor
        9 years ago

        Yes, of course!

         

        I use function DIVIDE([dz];[grs])*100 , when dz (debt sum) and grs(grossrev) are integer datas.

        I've added a few screenshots for better understanding.

        After this process I see 0 as a result.