Forum Discussion
Weighted average - help needed
Hello everyone, I am learning PowerBI and am trying to calculate an average value. I have the population size for a series of cities, across a number of years, and the population age C...
Weighted average can be computed like this:
AvgAge = DIVIDE ( SUMX ( Table1, Table1[Age] * Table1[Size] ), SUMX ( Table1, Table1[Size] ) )
AlexisOlson
Super User
Super UserYou'll need a SUM around the [numerator] in the Ratio.
Ashish_MathurSuper User
Super UserYes, that is correct.