Unique 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