Forum Discussion
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 si...
lbendlin
Super User
Super User
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.
Thanks for the tip, I removed it but unfortunately the measure still isn't working.
Any ideas on how I could rewrite the measure?