Cummulative / Running total based on 2 criteria

[rp2022]

Below is the data

Number	R	P	Label	Group	$
1	K	u1	PD	PD	100
j2	N	u2	PD	PD	200
3	N	u3	PD	PD	500
1	K	u1	Aug-24	Date	900
6	N	u2	PD < CY	PD < CY	600
t2	K	u4	Dec-24	Date	400
3e	N	u3	PD	PD	500
gt6	N	u2	Aug-24	Date	700
asdf3	K	u1	S	Date	800
asdf7845	N	u4	Dec-24	Date	9000
adfa564569	K	u3	PD	PD	100
1	N	u1	PD < CY	PD < CY	600
j3	N	u2	Jun-24	Date	6000
4	K	u3	S	Date	5000
f52r	N	u1	PD	PD	6500
7	K	u2	Jul-24	Date	266
t3	N	u4	Sep-24	Date	2555
3e	N	u3	Dec-24	Date	56632
gt7	K	u2	PD	PD	28996
asdf15687	N	u1	PD < CY	PD < CY	6352
1	K	u4	Sep-24	Date	5569
adfa564570	N	u3	Dec-24	Date	5626
3	N	u1	PD	PD	5989
j4	K	u2	Aug-24	Date	998
1	N	u3	PD < CY	PD < CY	889
1	K	u1	Dec-24	Date	7895
8	N	u2	PD	PD	8956
1	N	u4	S	Date	565
3e	K	u3	Sep-24	Date	56

And here the output i want:

I have a measure that does somewhat a good job, but when i filter by a perticular label, it shows values only for that label and not th ecumulative value. SO, I thought that i need a calculated column, which is not working.

Measure $ =

    VAR __group = MAX('Data'[Group])

    VAR __cur_date = MAX('Data'[Date])

    VAR __result = CALCULATE(SUM('Data'[Total $]),FILTER(ALLSELECTED('Data'),'Data'[Group]=__group && 'Data'[Date]<=__cur_date))

RETURN

__result

[rp2022]

I am sorry for the confusion, the output should look more like this: 

And should work for all filters like columns R, P, number etc

[ryan_mayu]

how you get 7034?

[rp2022]

1465+5569

[ryan_mayu]

@rp2022 

pls see the attachment below

[ryan_mayu]

what's the calculation logic? pls clarify how to get the expected output

[rp2022]

OOPS my bad, For S it should be more like 565

[ryan_mayu]

then how to get the output for 8/1,9/1 and 12/1?

[rp2022]

Calculated column  for Sum by 2 columns: Number and label

[ryan_mayu]

still not clear, for example , how to get 100 for S?