Rank is a table calculation which is on the bottom of the order of operations - After all the filters take place -
When you hover over the map you are passing the filters from the map to the second sheet where you determine the rank -
that filters the underlying table on the second sheet so there is only entity (region-district whatever) in the table - so it returns a
you can either return the entire table or return all values that are not table calculations -
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.