Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I am trying to calculate the cumulative sum based on another measure, and this cumulative sum must be responsive to all the applicable filters. I have consulted and tried the methods suggested in the following threads but all were not successful.
Solved: Cumulative sum Based on Measure - Microsoft Fabric Community
Solved: Cumulative of a measure based on Ranking - Microsoft Fabric Community
Solved: A Measure to Calculate the Cumulative Sum of Anoth... - Microsoft Fabric Community
Data Model
Category | Product | Country | Date | Value |
A | 1 | USA | 20/3/2025 | 5695 |
A | 2 | USA | 20/3/2025 | 9512 |
A | 3 | USA | 20/3/2025 | 5327 |
A | 4 | USA | 20/3/2025 | 1894 |
B | 5 | USA | 20/3/2025 | 8015 |
B | 6 | USA | 20/3/2025 | 8947 |
B | 7 | USA | 20/3/2025 | 4884 |
B | 8 | USA | 20/3/2025 | 3406 |
C | 9 | USA | 20/3/2025 | 4986 |
C | 10 | USA | 20/3/2025 | 8608 |
C | 11 | USA | 20/3/2025 | 9774 |
C | 12 | USA | 20/3/2025 | 9005 |
D | 13 | USA | 20/3/2025 | 6792 |
D | 14 | USA | 20/3/2025 | 2992 |
D | 15 | USA | 20/3/2025 | 1407 |
D | 16 | USA | 20/3/2025 | 5108 |
A | 1 | UK | 19/3/2025 | 9448 |
A | 2 | UK | 19/3/2025 | 1192 |
A | 3 | UK | 19/3/2025 | 6055 |
A | 4 | UK | 19/3/2025 | 3093 |
B | 5 | UK | 19/3/2025 | 4799 |
B | 6 | UK | 19/3/2025 | 8402 |
B | 7 | UK | 19/3/2025 | 6724 |
B | 8 | UK | 19/3/2025 | 3346 |
C | 9 | UK | 19/3/2025 | 8850 |
C | 10 | UK | 19/3/2025 | 5656 |
C | 11 | UK | 19/3/2025 | 8535 |
C | 12 | UK | 19/3/2025 | 3370 |
D | 13 | UK | 19/3/2025 | 4926 |
D | 14 | UK | 19/3/2025 | 9484 |
D | 15 | UK | 19/3/2025 | 2792 |
D | 16 | UK | 19/3/2025 | 1849 |
A | 1 | USA | 19/3/2025 | 2817 |
A | 2 | USA | 19/3/2025 | 8992 |
A | 3 | USA | 19/3/2025 | 6510 |
A | 4 | USA | 19/3/2025 | 9940 |
B | 5 | USA | 19/3/2025 | 1058 |
B | 6 | USA | 19/3/2025 | 3414 |
B | 7 | USA | 19/3/2025 | 1509 |
B | 8 | USA | 19/3/2025 | 1022 |
C | 9 | USA | 19/3/2025 | 7779 |
C | 10 | USA | 19/3/2025 | 1505 |
C | 11 | USA | 19/3/2025 | 5895 |
C | 12 | USA | 19/3/2025 | 6569 |
D | 13 | USA | 19/3/2025 | 4569 |
D | 14 | USA | 19/3/2025 | 1429 |
D | 15 | USA | 19/3/2025 | 5218 |
D | 16 | USA | 19/3/2025 | 1434 |
A | 1 | UK | 19/3/2025 | 1201 |
A | 2 | UK | 19/3/2025 | 5574 |
A | 3 | UK | 19/3/2025 | 4106 |
A | 4 | UK | 19/3/2025 | 4376 |
B | 5 | UK | 19/3/2025 | 3175 |
B | 6 | UK | 19/3/2025 | 6792 |
B | 7 | UK | 19/3/2025 | 3382 |
B | 8 | UK | 19/3/2025 | 7139 |
C | 9 | UK | 19/3/2025 | 6033 |
C | 10 | UK | 19/3/2025 | 2514 |
C | 11 | UK | 19/3/2025 | 2613 |
C | 12 | UK | 19/3/2025 | 6610 |
D | 13 | UK | 19/3/2025 | 3502 |
D | 14 | UK | 19/3/2025 | 3792 |
D | 15 | UK | 19/3/2025 | 8942 |
D | 16 | UK | 19/3/2025 | 3233 |
Formulas for Sales := Sales = SUM(FctTransaction[Value])
Formulas for Sales Contribution % := Sales Contribution % = DIVIDE([Sales],[Sales Total])
Formula for Rank := Sales Contribution % Rank = IF(ISINSCOPE(FctTransaction[Category]),RANKX(ALLSELECTED(FctTransaction[Category]),[Sales Contribution %],,DESC))
Expected Result
Actual Results
Formular for cumu. 1 :=
Formular for cumu. 2 :=
Solved! Go to Solution.
Hi @andrew_tran ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Hi @andrew_tran ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Hi @andrew_tran ,
we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Hi Chaithra, I haven't had the bandwidth to review lbendlin's suggestion, will update this thread ASAP
Hi @andrew_tran ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Hi Chaithra, I haven't had the bandwidth to review lbendlin's suggestion, will update this thread ASAP
Don't make this too hard.
Thank you so much for this! Sorry for the late response, I haven't had the bandwidth to study your suggestion, will get back to you asap
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
7 |