1 of 1 people found this helpful
if I understand you would like to filter the ranking sheet while holding the rank as a fixed value -
but filtering the table calculation affects the underlying table - also table calculations are at the bottom of the order of operation and cannot be used in lod expressions
so - there is not a way at the present time
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.
I suspected that it wasn't possible but wasn't 100% certain because there are workarounds if you aren't storing the data in the tool tip. I'll update here if I come across a solution.
Thanks for your help!