Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Weighted average can be computed like this:

    AvgAge =
DIVIDE (
    SUMX ( Table1, Table1[Age] * Table1[Size] ),
    SUMX ( Table1, Table1[Size] )
)
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

Weighted average can be computed like this:

AvgAge =
DIVIDE (
    SUMX ( Table1, Table1[Age] * Table1[Size] ),
    SUMX ( Table1, Table1[Size] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you AlexisOlson !

     

    Would it be the same if I wrote:

    AveAge = DIVIDE(SUMX (Table1, Table1[Age] * Table1[Size]), SUM(Table1[Size])) ?

     

    I don't understand why you are using the SUMX within the DIVIDE function....

     

    Thank you!

     

    AvgAge =
DIVIDE (
    SUMX ( Table1, Table1[Age] * Table1[Size] ),
    SUMX ( Table1, Table1[Size] )
)

     

    • AlexisOlson's avatar
      AlexisOlson
      Super User
      4 years ago

      Yeah, it should be the same.

       

      I kept the SUMX in the denominator only for aesthetic reasons to emphasize the parallel with the numerator.