Forum Discussion

Kolumam's avatar
Kolumam
Post Prodigy
8 years ago

Issue with Calculating percentage

Hi All,   Please see the below image.   I was trying to create a calculate column of [SUM( Y)/SUM(X) ]* 100 and create a pie chart but it's not working as expected. It doens't have the summ...
General Comment
Need Help
Show and Tell
quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

Hi Kolumam

 

You are only calculating the percentage of Y on X. 

 

Maybe you should try : 

 

DIVIDE(Calculate(SUM(Table[Y]);All(Table));Calculate(SUM(Table[X]);All(Table))

And then choose to display it as percentage 

 

- Quentin

  • Kolumam's avatar
    Kolumam
    Post Prodigy
    8 years ago

    I did but doesn't split up.. shows the same for all

    • FlaF's avatar
      FlaF
      Helper I
      8 years ago

      Did you calculate new columns with a formula like divide(sum(table.Y);sum(table.X))? or like divide(table.Y;table.X)?

      • Kolumam's avatar
        Kolumam
        Post Prodigy
        8 years ago

        Tried both. 

         

        It's not showing the split up of percentage.