Forum Discussion

ksivaganesh99's avatar
ksivaganesh99
Helper II
6 years ago

Filter one table from different tables

[ Spoiler ] Hi all,   I have four related tables to be modelled in the following manner. But not able to do as it is creating circular filtering across the tables. What is the best way I can handl...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, ksivaganesh99 

 

I'd like to suggest you use a star schema instead of a table pattern with loops. Cross filtering both directions works well for a pattern of table relationships as below.

 

If you have a table pattern like below, with loops, then cross filtering can create an ambiguous set of relationships. If you sum up a field from TableX and then choose to filter by a field on TableY, then it’s not clear how the filter should travel, through the top table or the bottom table.

 

For further information, please refer Create and manage relationships in Power BI Desktop 

 

Best Regards

Allan

 

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