DAX RANKX by Quarter
I am having issues creating a RANKX function that ranks values that are in the same period. My data contains multiple cities with multiple years and quarters for each city (Ex: Dallas for 1Q 2021, 2Q 2021..../Phoenix for 1Q 2021, 2Q 2021...). For each period I would like to rank the cities with regards to a specific metric (i.e vacancy). I have tried to accomplish this both through adding a column and meaures but have been unable to make it work. My current measure formula is: Test Vacancy Rank = RANKX(CALCULATETABLE(VALUES('Costar Data'[Vacancy Rate]),FILTER(ALLSELECTED('Costar Data'),'Costar Data'[End Of Quarter]=SELECTEDVALUE('Costar Data'[End Of Quarter]))),CALCULATE(SUM('Costar Data'[Vacancy Rate]))) I am less familuar with DAX so any help will be greatly appreciated. Thanks!