Forum Discussion

pbi_wannabe_exp's avatar
pbi_wannabe_exp
Regular Visitor
4 years ago
Solved

Weighted AVG Calculation

Hey all,   I have the following data table with many names but I only copied the table with 2 names now: setup.py and path.xyz. (date, name, loc_i, loc_d columns are originally in the table, and AG...
weighted average
  • lbendlin's avatar
    lbendlin
    4 years ago
    Wavg = divide(sumx('Table','Table'[AGE]*'Table'[Weight]),sumx('Table','Table'[Weight]))

     

    see attached

lbendlin's avatar
lbendlin
Super User
4 years ago
Wavg = divide(sumx('Table','Table'[AGE]*'Table'[Weight]),sumx('Table','Table'[Weight]))

 

see attached

pbi_wannabe_exp's avatar
pbi_wannabe_exp
Regular Visitor
4 years ago

Many thanks for your reply!! One thing I dont know is that how I can add weight calculation to the pbi. Only date, name, loc_i, loc_d is in the model. I understand how to add a calculated column measure in case of AGE and Weighted AVG, but what about Weight?