Forum Discussion
Ambiguous path fix for filtering when both paths are valid
One thing staff have raised is that in the filters they see information from the multiple companies even though they have chosen a company via a filter. Some of these I have solved by enabling the cr...
Make both paths inactive and then in your measures use USERELATIONSHIP to activate the appropriate path.
Thanks but SalesPerson and Branch are standard tables with the actual persons name or branch name within the joined tables, they are not measures. They are also not visable on the Matrix anywhere I am wanting to use these fields as available filters (standard filters not slicers). I will revisit and see if I can do something with a measure to resolve this. It would be good if you could apply the USERELATIONSHIP to a filter specifically to solve this. Thanks.
No, that's not possible unfortunately. Refactor your data model, or - worst case - use separate data models for the different business questions.