Help with Date Slicer in RANKX measure

Hi I'm having trouble getting date slicers to work with my rank measure, slicing by other dimensions works flawlessy, it is just when date is introduced that the ranking breaks.

I've created a similar mock dataset of car sales and this is what it looks like below. AVG sales price is a simple measure dividing revenue by number of sales and is the measure I want to rank these cars by.

My goal is to create a ranking based on the AVG sale price which changes dynamically when slicing by Car Make, Car Year, Color, Date etc.

With this measure I am able to get everything working other than by date

Avg Sale Price Rank = RANKX(

                                                 ALLSELECTED('Car Sales Mock'),

                                                 CALCULATE([Avg Sale Price],

                                                 ALLEXCEPT('Car Sales Mock','Car Sales Mock'[Car Make],'Car Sales Mock'[Car Year],'Car  Sakes Mock'[Color])),

                                                  ,DESC,Dense)

 

As you can see below, the ranking works, even when slicing by different colors. 

 

However, it breaks once we add in a filter for date as seen below.

 

 

Would appreciate if anyone could help wiht the DAX for this, here are some other measures I have tried but don't work.

 

Avg Sale Price Rank - 2 = RANKX(ALLSELECTED('Car Sales Mock'),CALCULATE([Avg Sale Price]),,DESC,Dense)

Avg Sale Price Rank - 3 = RANKX(ALLSELECTED('Car Sales Mock'),CALCULATE([Avg Sale Price],ALLEXCEPT('Car Sales Mock','Car Sales Mock'[Car Make],'Car Sales Mock'[Car Year],'Car Sales Mock'[Color],'Calendar'[Date])),,DESC,Dense)

 

Avg Sale Price Rank - 4 = RANKX(ALLSELECTED('Car Sales Mock','Car Sales Mock'[Car Make],'Car Sales Mock'[Car Year],'Car Sales Mock'[Color]),CALCULATE([Avg Sale Price]),,DESC,Dense)

 

^ this one is close to working and was provided by another user, but there are duplicate rankings and a few errors

 

PBIX file if you want to take a look and try

 

https://ilovesalt-my.sharepoint.com/:u:/p/mediadashboards/EciFcq9S6dpAhflGvkhyszUBTVlE6z-Lg-YL-iQ_XThO0g?e=GCrJDU

 

Thanks, 

Much appreciated