Forum Discussion

vendersonalias0's avatar
vendersonalias0
Frequent Visitor
5 years ago

How to get date filters working in RANKX measure?

  I have a mock table with 1000 rows of car sales data, shown above. There are only a handful of different car combinations and I am interested in seeing what the average selling price is acro...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

vendersonalias0 , Try once like this

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)

 

I have not checked the file yet

vendersonalias0's avatar
vendersonalias0
Frequent Visitor
5 years ago

Hi, thanks that seems to be very close, it is now working wiht the date slicer but it is skipping some numbers if the car didn't have any sales that month

Thanks, it seems liek were a step closer but there are still some weird variations such as two rank 7, and osmetimes they will skip a rank. 

 

I did have to adjust your measure to remove the table reference 'car sales mock' since it said that multiple argumetns are not allowed in the allselected function when the first argument is a table refrence.