Forum Discussion
Test Role : Join Paths are expected to Form a Tree. Two Join Paths To Table
- 9 years ago
My suspicion is that you really do have two join paths between the tables. This is usually the result of the cross-filter direction being in both directions on all relationships and you need to change one to be in a single direction. Can't really help more without a picture of the relationships.
For me the issue was that the measure that was being used, used CROSSFILTER to overrule some relationships. I re-wrote the measure to not use CROSSFILTER but something else (I stored the list of values I needed in a calculatetable, and referred to that instead of using any relationships at all).
What I still don't understand is that this measure broke when using RLS, but not when using the exact same filters using the filter pane or a slicer. Not sure what the real difference is between the two.