Forum Discussion

Fidzi8's avatar
Fidzi8
Helper V
6 years ago
Solved

Weighted average

Hi,

I need advice, please. 

I don´t know how I will calculate weighted average ( How I make new column with weighted average)? 

 

Column Trips is weight and column Priority is grade.

Avarege priority is (4+1)/2)=2,5 but I want weighted average (4*1+1*3)/4=1,75

 

Thank you 

Ondřej

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try a new measure like

    divide(sumx(Table,Table[Trips]*Table[Priority]),sum(Table[Trips]))

2 Replies

  • Geradav's avatar
    Geradav
    Responsive Resident
    6 years ago

    Fidzi8 

     

    You can use AVERAGEX() like this

    WeightedAverage =
AVERAGEX (
  MyTable,
  MyTable[Priority] * MyTable[Trips]
)

    Let us know if that works for you

     

    Best

     

    David 

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Try a new measure like

    divide(sumx(Table,Table[Trips]*Table[Priority]),sum(Table[Trips]))