Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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 Check casing. M does not consider a and A the same but DAX does.
@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?
@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 ?
@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 |
@Rose__123 Are both of your columns set to Text? Because if they are not, nothing will match.
@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?
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |