Hi Andrew Wong,
Its easy to achieve. You need to define the scope of the filter correctly.
I have attached a sample workbook which imitates what you have mentioned above. The workbook is built using sample superstore. Let me know if you have any queries.
Dashbaord Action.twbx 1.3 MB
Thanks Sujay, that is exactly what I needed.