Ranking and the lookup filter are table calculations that are at the bottom of the order of operations - all the filtering precedes the table calculations - when you are using the Sheet in viz features you are trying to filter from one sheet to another - with the tooltip action you are passing the Team from the first sheet to the second and it filters the table so only the one team remains -
the lookup filter will not pass from one sheet to another - you can't pass a filter based on a table calculation - it is based on the underlying table for the individual sheet'
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.