I broke the bar chart into two bar charts and the filter seems working fine.
Please check out the attached workbook for details.
And looking forward to better solutions.
Drill down issue.twbx 66.0 KB
Tableau is working as expected.
Following is my observation.
After selecting Member count, your expectation is to see respective values , perfectly fine. But default detail values shown are more than what is shown on the graph.
After you achieve respective values for details i think the issue will be resolved.