Weighted average

[Fidzi8]

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

[amitchandak · Accepted solution]

Try a new measure like

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

[Geradav]

@Fidzi8 

You can use AVERAGEX() like this

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

Let us know if that works for you

Best

David