Forum Discussion

Kolumam's avatar
Kolumam
Icon for Post Prodigy rankPost 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
FlaF's avatar
FlaF
Icon for Helper I rankHelper 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
Icon for Post Prodigy rankPost Prodigy
8 years ago

Tried both. 

 

It's not showing the split up of percentage.

  • FlaF's avatar
    FlaF
    Icon for Helper I rankHelper I
    8 years ago

    Are your data in the same database of the site name? Is there a link between data and the site name?

    • Kolumam's avatar
      Kolumam
      Icon for Post Prodigy rankPost Prodigy
      8 years ago

      Hi 

       

      The average of % solar is 31% but it is showing as 34% ( when I do SUM(annual PV consumed)/sum(annual Load)). How do I do a weighted average to acheive 31%?

       

      • FlaF's avatar
        FlaF
        Icon for Helper I rankHelper I
        8 years ago

        I have used your data and power bi has calculated the right average.

        I think there is a problem with the link between your data, but I'm not sure