Ankit I figured out how to make the Sales Tax Per Capita show for every line. I studied your measure and created a new measure like so
`Sales Tax Per Capita Display = CALCULATE( [Sales Tax Per Capita],ALL(tbl1City))``
I was also able to modify one of your measures to display the selected city rank.
RANK DISPLAY 2 = VAR SELCITY = SELECTEDVALUE(tbl1City[Municipality])
VAR SELRANK = CALCULATE([Census Pop Rank FY],ALL(tbl1City),FILTER(ALL(tblCityPopulationByYear),tblCityPopulationByYear[Municipality] = SELCITY))
Return SELRANK
I think the first part of this question is answered! I really appreciate your assistance! I will post another questions in regards to the sales tax rate.
EDNA Solution - Rank 5 above and 5 below-tjohnson working solution.pbix (9.1 MB)