I believe you are on the right track by using a FIXED Level of Detail (LOD) expression. However, as you discovered, FIXED ignores dimension filters. There are a few ways around this. One is to use an INCLUDE LOD instead of FIXED. Another is to promote the dimension filter to a Context filter.
If you can attach a packaged workbook (.twbx) illustrating your attempts and challenges, we can help find a working solution. Please see Getting the Most From the Tableau Forums and Anonymize your Tableau Package Data for Sharing for more information.