Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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()) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |