Forum Discussion
The average from average
Hi Folks, i am a Newcomer in Power BI and i have a question: my table does look like: Projekt, Projectscore, PointA, PointB A, 66, 67 %, 80, 120 B 31,25 %, 50, 160 ...
Hi Zhao,
thanks a lot for your responce, my issue does look like:
Project, Aver, PointA, PointB
a, 67,22%, 363, 540
b, 53,61%, 193, 360
c, 69,64%, 195, 280
d, 69,00%, 31, 50
e, 37,22%, 67, 180
f, 61,14%, 107, 175
Total: 60,32% 956, 1585
but instead of 58,47% my total avergae is: 60,32%, how can i calculate my averages to have the value 58,47 %
i hope, i explained well, if not, please let me know
Hi Anonymous ,
I'm not sure whether you are using my meausre, that's what you want, I try it in my desktop.
Measure = AVERAGEX('Table',DIVIDE(CALCULATE(SUM('Table'[PointA])),CALCULATE(SUM('Table'[PointB])),0))
Aiolos Zhao