Pareto Chart with multiple aggregation levels

Dear all,

I am trying to create a pareto chart that allows me to visualize the amount of deliveries categorized by different codes, whereas I am able to switch on slicer filter from year, to months, to calendar week.

The data source is one huge excel file with data on very granular level.

So far I succeeded in getting a correct ranking, which is neccessary to cumulate the numbers.

However, only the cumulation on the most granular level is correct and I think it has something to do with this ALLEXPECT function. If I remove let's say Calendar Week (Calendar Year/Week) from the ALLEXPECT statement then the cumulation on monthly level is correct, but overall year and weekly is incorrect.

Do you have any ideas how I could fix the code?

DC Analysis is the name of the table, Delivery Code labels the respective delivery (direct, indirect, express,...)

Ranking = RANKX(ALL('DC Analysis'[Delivery Code]);
			CALCULATE(SUM('DC Analysis'[Amount of Deliveries]);
			ALLEXCEPT('DC Analysis';'DC Analysis'[Delivery Code];'DC Analysis'[Calendar Year/Month];'DC Analysis'[Calendar Year/Week])
							);;DESC)


Cumulative Total = CALCULATE(
 SUM('DC Analysis'[Amount of Deliveries]);
 FILTER(ALLSELECTED('DC Analysis');
 [Ranking]<= MAXX('DC Analysis';[Ranking])
 ))