Forum Discussion

Helper I

3 years ago

Solved

weighted average calculation

Hi there,

really struggling to find a solution for this, hope someone can help.

i am trying to calculate the weigted average of "vol" per item.

next to vol column i want to see something like below

LINK TO FILE - TEST- Copy.pbix

appreciate if anyone can help, thanks in advance.

best regards

timur

amitchandak
3 years ago
timurcakin , Try like

Divide([vol]), Calculate([vol], allselected()) )

4 Replies

amitchandak
Super User
3 years ago
timurcakin , If volume is column

Divide(Sum(Table[VOlume]), Calculate(Sum(Table[VOlume]), allselected()) )

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
- timurcakin
  Helper I
  3 years ago
  Hiamitchandak ,
  Volume is measure, shared the link if needed
  - amitchandak
    Super User
    3 years ago
    timurcakin , Try like
    
    Divide([vol]), Calculate([vol], allselected()) )

Related content