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
User | Count |
---|---|
145 | |
65 | |
62 | |
59 | |
49 |
User | Count |
---|---|
140 | |
65 | |
62 | |
62 | |
56 |