Forum Discussion
How to create multiple active relationships among tables?
Hi,
Good Morning everyone! Thanks for your help in advance!
So I m trying to do an analysis of a data and I have created active relationship based on the activity owner. However, each activity owner currently overseas 7-8 countries hence I wanted a next level slicer on country. However, since only one active relationship (owner) exists between 4 of my tables, when I select the owner in the slicer all the data gets updated in the dashboard. However, when I further (additionally) select the country, the data does not get updated as it is not an active relationship. Please help as I want to use 2 active relationships for my data across 4 tables.
Thanks
7 Replies
- CiceroBC
Advocate II
Anonymous,
This might be a scenario where changing your table relationships to use "Many to Many" cardinality could work. Can you dictate the cross-filter direction, so the selection of a country only filters one side of the relationship? Not sure if that would work with your table structure, but it might be an option.
Good luck!- GilbertQ
Super User
Hi there
What I would suggest is to remodel your data so country could be a dimension in your data model. This will allow you to cross filter automatically on both the owner and or country. That is best practise in terms of performance.
This will also mean that the DAX is a lot easier.
Both bi-directional cross filter directions and many to many should be looked at very carefully as it can result in the wrong values being displayed
