Many to many relationship - why?

[Rose__123]

Hi

I don't understand why this becomes a many-to-many relationship? Commission_exeption_table[customer_code] contains no repetitions, but salesInvoices[customer_code] does, I would think it should be a many to one relationship. Both are formatted as text. 

[Greg_Deckler]

@Rose__123 Check casing. M does not consider a and A the same but DAX does.

[Rose__123]

@Greg_Deckler, I double-checked, but it was fast since my Commission_exeption_table only contains two rows.  Any other ideas?😅 The only thing I can think of is the blank spaces of the Commission_exeption_table since these also appear (and should appear) in the salesInvoices[customer_code], but can that be? 

[Greg_Deckler]

@Rose__123 It's really difficult to say without the ability to see the data. Since it is only two can you make up two that are equivalent to your two ID's? Is the only difference the number of spaces or ?

[Rose__123]

@Greg_Deckler sure! So right now they are like this:

 Commission_exeption_table

customer_code	Commission
123456	2
12345678	3

and

 salesInvoices

DueDate	customerPurchaseOrderReference	CustomerID	customer_code
01-01-01	335534-435643-3456	1	12345678
02-02-01	135534-435643-34561	2	12344
02-02-01	535534-434343-34562	3	AB123
03-03-03	435534-435213-3456432	1	12345678

[Greg_Deckler]

@Rose__123 Are both of your columns set to Text? Because if they are not, nothing will match.

[Rose__123]

@Greg_Deckler, yes both are formatted as text

[Greg_Deckler · Accepted solution]

@Rose__123 The only way that I could replicate this was to have a blank row in Commission_exception. A blank customer_code. Do you have that?

[Rose__123]

@Greg_Deckler, well not anymore 😂 It works, thank you very much for your time!