Forum Discussion
Join paths are expected to form a tree
Judging from the fact that you have 3 Many-to-Many Relationships as well as 2 bi-directional relationships, and have spent a week troubleshooting your errors, it is high time for you to invest in a copy of Microsoft's The Definite Guide to DAX. This will walk you through when and why to use them as well as additional techniques e.g. bridge tables. Very little can be communicated in a forum on how to fix your data model. Only you understand your data model and your requirements.
Continued ContributorJudging from the fact that you have 3 Many-to-Many Relationships as well as 2 bi-directional relationships, and have spent a week troubleshooting your errors, it is high time for you to invest in a copy of Microsoft's The Definite Guide to DAX. This will walk you through when and why to use them as well as additional techniques e.g. bridge tables. Very little can be communicated in a forum on how to fix your data model. Only you understand your data model and your requirements.
Thanks, I've removed one bidirectional relationship. I'm reading about bridge tables here https://www.seerinteractive.com/insights/join-many-many-power-bi, that opened a possible way to go! I'll try to test it today.
gonna buy that book 😂
With the bridge method I have it working now! the data model became a lot simpler... Thanks for pointing me in the right direction!
