Forum Discussion
Helper IRelationships with multiple look up tables
I'm having a bit of trouble imagining what you're describing, but here's what I would suggest:
1. Power BI by default makes the relationships bi-directional, go ahead and turn that off on all the relationships - make them go only one direction.
2. You already know this but I have to say it - don't connect your lookup tables directly to each other and don't connect your data tables directly to each other.
But yeah take a little screenshot and that would help people help you.
Hi there , could you help me ? I'm having the some trouble .
I have a big hierarchy which is working fine .The hierarchy tables are linked like this hierarchy_1[nodeID] 1----->* hierarchy_2[parentID].
My problem is whenever I have a look up table , I want to be able to link it with all of the hierarchy . I can't because of ambiguity between relationships . I already did everything you told to do .
In case you didn't understood my question , I want to be able to link casefiles with all hierarchy tables without having ambiguity problems ..