Forum Discussion
Circular dependency
Hi matze ,
You can create one relationship between (1) and (2), one relationship between (2) and (3), and there is no need to create relationship between (1) and (3), just change the Cross filter direction of all relationships from Single to Both, which will take the three tables treated as a single table.
You can learn more about relationship :https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi matze ,
You can create one relationship between (1) and (2), one relationship between (2) and (3), and there is no need to create relationship between (1) and (3), just change the Cross filter direction of all relationships from Single to Both, which will take the three tables treated as a single table.
You can learn more about relationship :https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.