Help with Date Slicer in RANKX measure

[vendersonalias0]

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_XT...

Thanks, 

Much appreciated

[lbendlin]

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'[Color]),ALLEXCEPT('Calendar','Calendar'[Year],'Calendar'[Quarter],'Calendar'[Date])),,DESC,Dense)

Remove your Auto Date/Time stuff, it is not helpful.

[vendersonalias0]

Thanks for the tip, I removed it but unfortunately the measure still isn't working.

Any ideas on how I could rewrite the measure?