Forum Discussion
Data Modelling & Slicer
Hi, I try to build a simple relationship between 2 tables - Client & Group and a intermediate table (Many : Many).
Client
Group
ClientGroup (intermediate)
Relationship is as below
What I would like to do is to click Filter (on left) and filter out related client (on the right).
The current setup doesn't work as expected, and i am wondering if there is error int he data modelling (relationship). Any suggestions? Thanks
See if one of these options helps:
- In the relationship between the Gruop and ClinetGroup tables, change the cross filter direction to "both";
- Include in your visual table the customer that is in the ClinetGroup table.
3 Replies
Hi,
One cannot build a relationship between the tables unless there is a ClientID column in the Group table or a GroupID column in the Client table.
See if one of these options helps:
- In the relationship between the Gruop and ClinetGroup tables, change the cross filter direction to "both";
- Include in your visual table the customer that is in the ClinetGroup table.
VilmarSch Thanks for the reply. I've changed the relationship as below, and it seems to work.
Will there any potentialy issues when we setup relationship to be both directions? Thanks again
