Data Modelling & Slicer

[spagad6263]

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

[spagad6263]

@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

[VilmarSch · Accepted solution]

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.

[Ashish_Mathur]

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.