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.
Impactful IndividualI'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.
Helper IWorks like a charm, thank you!