cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shubham
Helper V
Helper V

Issue with Manage Relationship

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.

1 ACCEPTED SOLUTION
Habib
Responsive Resident
Responsive Resident

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.

View solution in original post

2 REPLIES 2
Habib
Responsive Resident
Responsive Resident

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.

View solution in original post

Double Like.. Thanks for the solution. 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors