Hi,
I'm having an issue with my relationships between tables and curious if someone knows how to deal with this issue.
Below is a screenshot of my 4 tables.
I believe this is a classic one - to - many tables that should work, however when i try to put column from table 1,2 and 3 the tables breaks and tells me it can't determine the realtionships between the field. It works fine when i combine table 2,3 and 4, but there seems to be an issue connecting table 1 with 3 and 4.
Appreciate any help.
Thank you
@Anonymous it is because Table 1 is on many side of the relationship and it cannot filter Table 2 (which is on one side). On relationship, change cross filter direction to both and it should work.
Would appreciate Kudos 🙂 if my solution helped.
PS - It is not recommended to cross filter direction to both as it can have performance impact.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Tough to be 100% certain, but it sounds like you are describing a multiple pathway issue where you end up with multiple filter paths between 2 tables. You can go ahead and create an inactive relationship and use USERELATIONSHIP within DAX to pick the inactive relationship.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
@Anonymous it is because Table 1 is on many side of the relationship and it cannot filter Table 2 (which is on one side). On relationship, change cross filter direction to both and it should work.
Would appreciate Kudos 🙂 if my solution helped.
PS - It is not recommended to cross filter direction to both as it can have performance impact.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
