Forum Discussion
Post PatronUnique Values and Relationship issue with blank values looking like duplicates?
Hi unclejemima,
In your scenario, I’m afraid you could not create a relationship between the two columns. Because duplicate values are both in your ‘Account’[UniqueNumberSupplier] column and ‘Inventry’[Supplier] column. Power BI doesn’t support this many-to-many relationship. You can view related links about this: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships#cross-filter-direction
I suggest you to create a bridge table that has distinct value of ‘Inventry’[Supplier] from both tables. Then you can create relationships among these three tables N:1:N (Account table <-> Bridge table <-> Inventry table).
Regards,
Daniel He
Microsoft EmployeeHi unclejemima,
In your scenario, I’m afraid you could not create a relationship between the two columns. Because duplicate values are both in your ‘Account’[UniqueNumberSupplier] column and ‘Inventry’[Supplier] column. Power BI doesn’t support this many-to-many relationship. You can view related links about this: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships#cross-filter-direction
I suggest you to create a bridge table that has distinct value of ‘Inventry’[Supplier] from both tables. Then you can create relationships among these three tables N:1:N (Account table <-> Bridge table <-> Inventry table).
Regards,
Daniel He
Hey, v-danhe-msft.
Can we create a bridge table that only has one column - the key?
In the visuals, if Cross-Filter is set to "Both" on both ends, we can relate every column from N tables? The filter propagates through the Bridge right?