Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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.
@Anonymous
You might need to change aggregation or add a measure.
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |