Cumulative sum is not recalculating based on sort my measure Sales

[Manish1005]

Current table visual
Table:Sales

Item	Sales	Sales%	Comulative Sum	Comulative %
A	5000	31.06%	5000	31.06%
B	2000	12.42%	7000	43.48%
C	3000	18.63%	10000	62.11%
D	6000	37.27%	16000	99.38%
E	100	0.62%	16100	100.00%
Total	16100	100.00%	16100	100%

Current logic i used in above table:

Sales = sum(Sales[Sales Amount])

Comulative Sales =calculate(sum(Sales[sales Amount]),filter(allselected('Sales'),

                             Sales[Sales Amount]<=MAX(Sales[Sales Amount])

Total Sales Amount=calculate(sum(Sales[Sales Amount]),allselected(Sales))

Comulative % = Divide(Comulative Sum, Tital Sales Amount)

When Calculated measure Sales mount Sort by Desc then Comulative sum could be recalculate order by

Item	Sum(Sales Amount)	Sales%	Comulative Sum	Comulative %
D	6000	37.27%	6000	37.27%
A	5000	31.06%	11000	68.32%
C	3000	18.63%	14000	86.96%
B	2000	12.42%	16000	99.38%
E	100	0.62%	16100	100.00%
Total	16100	100.00%	16100	100%

Thanks in Advance!

[lbendlin]

don't use MAX inside CALCULATE.  Mind the filter context transition.  Use variables.