weighted average calculation

[timurcakin]

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]

@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]

Hi@amitchandak ,

Volume is measure, shared the link if needed

[amitchandak · Accepted solution]

@timurcakin , Try like

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

[timurcakin]

thanks @amitchandak  works like a charm!