Forum Discussion

HitcH's avatar
HitcH
Icon for Helper II rankHelper II
3 years ago

EASY Formula not working

Hi everyone

I have two measures and I want to calculate the percentage one of the other:

I expected the value to be 79% but I get 2%. This is probably a very stupid question but it's late and I can't solve it by myself 😮

6 Replies

  • You may try

    Measure =DIVIDE(sum([first column]),sum([second column]))

    • HitcH's avatar
      HitcH
      Icon for Helper II rankHelper II

      Wow, the value has changed, but it is not the correct one yet

       

      • Padycosmos's avatar
        Padycosmos
        Icon for Solution Sage rankSolution Sage

        If the data is not sensitive could you please share the pbix file?

  • measure=DIVIDE(sum(1st & 2nd column),sum(2nd column))

     

    If I answered your question mark it as solution.