Cumulative sum based on rank and category

[kleetus51]

I have a dataset that ranks all values by a KPI category. I'd like to add a Cumulative column that sums all values that rank at or below the current record in the same category. How would I calulate the data to get the results in the last column below?

KPI	Rank	Value	Cumulative Value
GM $	1	$4,979	$31,968
GM $	2	$4,586	$26,989
GM $	3	$4,460	$22,403
GM $	4	$3,439	$17,943
GM $	5	$3,405	$14,504
GM $	6	$3,293	$11,099
GM $	7	$2,716	$7,806
GM $	8	$1,400	$5,090
GM $	9	$1,190	$3,690
GM $	10	$712	$2,500
GM $	11	$617	$1,788
GM $	12	$611	$1,171
GM $	13	$307	$560
GM $	14	$253	$253
Sales $	1	$8,769	$51,412
Sales $	2	$6,949	$42,643
Sales $	3	$6,770	$35,694
Sales $	4	$6,256	$28,924
Sales $	5	$5,712	$22,668
Sales $	6	$4,897	$16,956
Sales $	7	$4,818	$12,059
Sales $	8	$3,972	$7,241
Sales $	9	$1,716	$3,269
Sales $	10	$1,553	$1,553

[HotChilli · Accepted solution]

ColumnN = var _kpi = TableF[KPI]
var _rank = TableF[Rank]
RETURN
CALCULATE(SUM(TableF[Value]), FILTER(TableF, TableF[KPI] = _kpi && TableF[Rank] >= _rank))

as a column

[kleetus51]

Works great, thanks!