Create a Static Ranking Card Visual from a measure

All,

I am trying to create a Card Visual showing the rank of sales values in a given week based on a measure, "Net Sales", which is being filtered on the page by two items - the store location (Column "DBA") and the week (Column "FW Ending").  I am able to create a table showing the rank of the Net Sales for each store during the week when I select all stores in the page level slicer, but when I select a specific DBA location, it loses all of the ranking and simply returns a value of "1" for the store selected, even if that store is ranked, say, 33rd when I show the full table.  I want to be able to keep the ranking associated with the store when all locations are selected when I filter the page by individual stores. Is this possible?  Thanks in advance for any help.