Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello All,
I would like to get the result the same as tabel below:
I can get total by customer, rank and % by Rank. but I donlt know how to get "cummulative % by rank". Pls. instruct me how to get it. Thanks.
Customer | sales | Total by customer | Rank | % by Rank | cummulative % by Rank |
A | 1000 | 3000 | 1 | 50% | 50% |
B | 200 | 900 | 3 | 15% | 82% |
C | 300 | 600 | 4 | 10% | 92% |
D | 500 | 500 | 5 | 8% | 100% |
E | 1000 | 1000 | 2 | 17% | 67% |
A | 2000 | 3000 | 1 | 50% | 50% |
B | 700 | 900 | 3 | 15% | 82% |
C | 300 | 600 | 4 | 10% | 92% |
Total | 6000 |
Solved! Go to Solution.
You can do it like this:
VAR CurSales = CALCULATE( SUM( Data[sales] ), ALLEXCEPT( Data, Data[Customer] ) ) RETURN DIVIDE( CALCULATE( SUM( Data[sales] ), FILTER( ALL( Data[Customer] ), CALCULATE( SUM( Data[sales] ), ALLEXCEPT( Data, Data[Customer] ) ) >= CurSales ), ALL( Data ) ), SUM( Data[sales] ) )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
You can do it like this:
VAR CurSales = CALCULATE( SUM( Data[sales] ), ALLEXCEPT( Data, Data[Customer] ) ) RETURN DIVIDE( CALCULATE( SUM( Data[sales] ), FILTER( ALL( Data[Customer] ), CALCULATE( SUM( Data[sales] ), ALLEXCEPT( Data, Data[Customer] ) ) >= CurSales ), ALL( Data ) ), SUM( Data[sales] ) )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Thank you for your feedback. I did the script but there is syntex error. Did I something wrong?
Hi bluetronics,
You should add a column name before the formula.(e.g.:
)
Regards,
Jimmy Tao
Thanks a lot! it works. 🙂
I found the queations what I would like to know. But I still don't understand how to do it.
Pls. help me someboy know the answer.
https://community.powerbi.com/t5/Desktop/Running-total-with-ranking/m-p/323103#M144010
Thanks in advance.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |