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

       

    • v-piga-msft's avatar
      v-piga-msft
      Icon for Resident Rockstar rankResident Rockstar
      8 years ago

      Hi Kolumam,

       

      Have you solved your problem? If not, please share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

       

      Best Regards,

      Cherry