Forum Discussion
Kolumam
Post Prodigy
Post ProdigyIssue 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...
KolumamPost Prodigy
Post ProdigyHi
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%?
v-piga-msft
Resident Rockstar
Resident RockstarHi 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