Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Relationship Problem and filter direction

Hi, we have the attributes as Employee,Sales,Product,Country and the relationship between them as follows. we are facting filter problems in the following relationsip .The problem is we were un able...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    It's impossible to create relationship as below:

    Because if you do this, there are two relationship lines between the Sales table and the Country table. This is not allowed, and only one relationship can exist between the two tables.

    In fact, how you establish relationships between tables depends on how you want to create the visualization.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

It's impossible to create relationship as below:

Because if you do this, there are two relationship lines between the Sales table and the Country table. This is not allowed, and only one relationship can exist between the two tables.

In fact, how you establish relationships between tables depends on how you want to create the visualization.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.