I have a workbook where I need to filter on certain measure and not others. So I duplicated the data source and joined where necessary. The problem is the joins don't pull through properly on the fields which are unfiltered. They sometimes do but I think it's because of the join type restriction.
So I created the joins myself via custom SQL. However, with 1 data source I now cannot filter on certain measures, everything is then affected.
I tried to apply the Fixed and Exclude functions but can't seem to get it to work. Any ideas would be greatly appreciated.
I understood your issue but i can't figure out how to help you only with your explanation.
Maybe you can use parameters with your custom sql.
Can you post same data?