Cumulative sum based on another measure

[andrew_tran]

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 := 

Sales Contribution % Cumulative 1 =

SUMX(

    FILTER(ALLSELECTED(FctTransaction)

        ,[Sales Contribution % Rank]<=MAXX(ALLSELECTED(FctTransaction),[Sales Contribution % Rank])

    )

    ,[Sales Contribution %]

)

Formular for cumu. 2 := 

Sales Contribution % Cumulative 1 = 

Sales Contribution % Cumulative 2 =

VAR CurrentRank = [Sales Contribution % Rank]

RETURN

SUMX(

    TOPN (

        [Sales Contribution % Rank]

        ,CALCULATETABLE(VALUES(FctTransaction[Category]),ALLSELECTED(FctTransaction[Category]))

        ,[Sales Contribution % Rank]

        ,ASC

    )

    ,[Sales Contribution %]

)

Could any expert help to advise? Thank you so much!!

I have also tried to attach the underlying pbix file but was not able to do so, so my apologies.

[v-echaithra]

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,

Chaithra E.

[v-echaithra]

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,

Chaithra.

[v-echaithra]

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,

Chaithra

[andrew_tran]

Hi Chaithra, I haven't had the bandwidth to review lbendlin's suggestion, will update this thread ASAP

[v-echaithra]

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,

Chaithra.

[andrew_tran]

Hi Chaithra, I haven't had the bandwidth to review lbendlin's suggestion, will update this thread ASAP

[lbendlin · Accepted solution]

Don't make this too hard. 

[andrew_tran]

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