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%?
FlaF
Helper I
Helper II 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