Forum Discussion
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...
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%?
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