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,
can you please help to calculate the running total of weighted volume % for attached file?
i am trying to find the "running total weighted volume %, its pretty easy to do it on excel, and appearantly not so easy on power bi
item | qty | order | volum | volume % | running total weighted volume% |
ZUB1379-LED | 126 | 6174 | 777924 | 95.77% | 95.77% |
ZUB1380-LED | 42 | 714 | 29988 | 3.69% | 99.46% |
ZUB1378-LED | 22 | 176 | 3872 | 0.48% | 99.94% |
ZUB1379 | 10 | 40 | 400 | 0.05% | 99.99% |
ZUB1378 | 6 | 12 | 72 | 0.01% | 99.99% |
ZUB13968502 | 4 | 8 | 32 | 0.00% | 100.00% |
ZUB1380 | 4 | 4 | 16 | 0.00% | 100.00% |
i am not very good at DAX, thanks in advance.
@timurcakin , Create a new measure, assumed volum is a measure
divide([volum], calculate([column], allselected() ) )
There is option on right click of measure to show as % of total
refer
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |