Forum Discussion
Solved
Join paths are expected to form a tree
Hi everyone, I've been trying to solve this problem for a week but can't find a workable solution - a bit tired and desperate by now! I've read many forums here about the same problem and the mic...
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.
lbendlin
Super User
Super UserAs the message says - you have ambiguity in your data model. May want to clean that up. You also have two bidirectional joins - try to avoid these.