Forum Discussion
tomas12344
Helper III
Helper IIIcalculate average from aggregated values
HI All Custome want a report, where the average is calcualted from aggregated values not from detail values of the table. The report table contains some hierarchies, base on which the data should ...
amitchandak
Super User
Super Usertomas12344 , seem like you need Avg of sum
Averagex(Values(Table[Level1]), calculate(Sum(Table[Value])) )
The values will be avg above "Level1" , field
Avg of Sum : https://youtu.be/cN8AO3_vmlY?t=22980