I would approach this with an LOD that fixes the topic and location - then use that in the top 10 filter
Think about using a parameter to control the topic selection - it will look like a filter to the user but will affect the entrie workbook
then filter based on the parameter (all sheets)
I threw the 2 sheets on a dashboard that is driven by the parameter
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.
Dash 1 Trial 1.twbx 125.0 KB