Cumulative totals based on descending order of Count

[105TT]

Hi, I am able to get cumulative total on sorting order of Category using below formula, but i want to calculate Cumulative total based on descending sorting order of Count. How can I do this? Thanks in advance!

Cumulative = CALCULATE(SUM(Table[Count]), FILTER(ALL(Table), Table[Category]<= MAX(Table[Category])))

Cateogy	Count	Cumulative
A	27	27
B	4	31
C	1	32
D	2	34
E	1	35
F	4	39
G	1	40

[aditya0125]

Reverse Cumulative Count = calculate(total count), filter(allselected(dates), dates[date]>=Min(dates[date])))
try this one.

[amitchandak]

@105TT , Use window function , refer my example

//Min Feb-2023 release

Cumm Based on net = CALCULATE([Net], Window(1,ABS,0,REL, ADDCOLUMNS(ALLSELECTED('Item'[Brand]), "_net", [Net]),ORDERBY([_net],DESC)))

Cumm Based on Brand = CALCULATE([Net], Window(1,ABS,0,REL, ADDCOLUMNS(ALLSELECTED('Item'[Brand]), "_net", [Net]),ORDERBY('Item'[Brand],asc)))

Check Cumm

Power BI Window: Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw