Use of action filters will be good for your scenario.
I have tried action filters so far have been unsuccessful in my attempts.
Please provide sample workbook or sample data.
Project Officer (Data Analysis)
National Ethnic Disability Alliance (NEDA)
Ph: 02 6262 6867
180 London Circuit, Canberra ACT 2600
PO Box 971, Civic Square ACT 2608
‘An inclusive Australia where cultural diversity and disability rights are essential aspects of an equitable society’.
It looks like you'd benefit from the sheet swap parameter like the article below.
If you want to simplify it, you can also look into using the parameter to swap measures like the article below.
Please see the attachment for an example of a sheet swapping parameter.
ACT Maps_k.twbx 11.9 MB