Forum Discussion

Lexey's avatar
Lexey
Helper I
8 years ago

Percentage between two values

Please help in solving one problem. You need to calculate the percentage as the ratio of [delta plan] and [plan]. Tried different options but have not yet found solutions.
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Lexey,

 

What you want to calculate is 2198/3548=0.6195 for the first row under [delta % plan], right?

 

If so, you should modify the measure [delta % plan] as below:

delta % plan = [delta plan]/ [Values of budget]

 

Best regards,

Yuliana Gu

  • Lexey's avatar
    Lexey
    Helper I
    8 years ago

    I need row context.,
     1 row = [delta plan]/[Values of budget]
     2  row = [delta plan]/[Values of budget]
    3 row = [delta plan]/[Values of budget]

     

    you get a total percentage that doesn't suit me. Thanks

    • Floriankx's avatar
      Floriankx
      Solution Sage
      8 years ago

      You could try SUMX(Table;[delta plan]/[Values of budget].

       

      This is for a Measure.

      Calculated Column would just be [delta plan]/[Values of budget]

       

      I'm not quite sure wether your columns is name Values of budget or plan.

       

      Please try and let me know.

      • Lexey's avatar
        Lexey
        Helper I
        8 years ago

        Thanks
        I didn't get quite the right result

         

        delta % plan = sumx('fact'; [delta plan]/ [Values of budget])