Without an actual workbook I can't give specifics, but you want to have a table calc as a filter so that it leaves all the other teams in the underlying table.
So if you have a parameter for the user to select a team, make a filter something like this:
LOOKUP( (if [team name] = [team parameter] then 1 else 0 end), 0 )
There are two arguments to that LOOKUP. the first is an IF statement that results in 1 or 0. the second is the value 0 to tell tableau to look at the current mark (for each mark).
When you put that on the filter shelf you will have choices of value 1 or 0. Select for 1. This will bring only the selected team onto the viz. But all the other teams are still in the underlying table, and your RANK will take them all into account.
Thanks so much Joe, I really appreciate the quick response.
I'm getting an error message using the filter you provided above. Attached is a packaged workbook with dummy data - are you able to test it in there?
JJ Sponsorship Dashboard for TC.twbx 930.3 KB
Note: I changed the color pill to discrete so that you get individual colors for each value instead of a spectrum.
The error you were getting was probably the aggregate error. (Must be aggregate.)
LOOKUP is a table calc, so components in it must be aggregated. Wrapping a non-aggregate in ATTR() is a common way to fix that. Usually we are messing with measures, so they would get SUM() or MIN(), etc., as the table calc expects.
This is perfect and my dashboard is working, thank you so much for your help!