Forum Discussion

Fidzi8's avatar
Fidzi8
Icon for Helper V rankHelper 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. Avare...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try a new measure like

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Try a new measure like

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