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
Solved! Go to Solution.
@timurcakin , Try like
Divide([vol]), Calculate([vol], allselected()) )
@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 , Try like
Divide([vol]), Calculate([vol], allselected()) )
User | Count |
---|---|
142 | |
61 | |
59 | |
58 | |
47 |
User | Count |
---|---|
136 | |
72 | |
59 | |
56 | |
52 |