Issue with Manage Relationship

[Anonymous]

Hi, I am facing an issue in "Manage Relationship".

I have 3 dataset queries consider as fact data having date and city columns. Query1, Query2, Query3

I have two master dataset which is having date and city master data (unique data). 

Now I have to use Report Level Filter for using Date and City values as filter for all three fact queries. 

Now the problem is, I can make only single relationship between Date and City master with fact queries. Further relationship showing inactive due to ambiguity.

I have three visuals by three fact queries each which I cannot merge. Could you please help me out here how can I do this and provide report level filter to users so that they can select either Date or City values or both for filtering all 3 visuals simultaneously.

[Habib · Accepted solution]

Please create relationship with both datasets. One relationship will be active whereas other will be non active. It will be changed to non active automatically but you can still refer to this relationship using USERELATIONSHIP in DAX. If you want any of your measure to be computed based on inactive relationship you can enforce this through above function.

[Anonymous]

Double Like.. Thanks for the solution.