Forum Discussion
The average from average
Not clear, you want to add a new row
For Avg of Avg refer
https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Hi amichandak, first of all, thanks a lot for your responce,
i don't want to add a new row, i just want to calculate my average, here is my situation:
my real example 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