As title, I intend to apply different filter to different measure value from two data source. For example, i have 2 filter now: filter A and filter B. And 2 different measure values from 2 sources: Sum of Sales 1 from data source 1 and sum of Sales 2 from data source 2.
I want to apply ONLY filter A to Sum of Sales 1 and filter B to Sum of Sales 2 in single worksheet.
Is that possible? or any alternative ways to do?
Thanks you very much for suggestion!!
Most likely not as it depends on the relationship of the 2 data sources and what dimensions they are blended on. When you filter on one it will be filtering on the other data source by way of the blend relationship.