Duplicate value not allowed, many to many

[vazperen]

Hello, Newby with databases and PowerBI.  I was creating a table with Horse racing results and everything went well until one horse finally showed up again under the results table.  I have two tables, one called Horse Results, and another called Picks.  I checked the relationship properties, based on some other comments, I believe I have it as many-to-many with cross filter direction as "both".  Probably is something is easy to fix..thanks of the input.

[vanessafvg · Accepted solution]

@vazperen you will need to create a distinct list of horses, you cannot do many to many directly, there has to be a unique lookup table in the middle, get a distinct list of the horse column and place it between the tables you have remapping the relationship.

do you need a many to many relatioship?   where are you filtering the data from in your visuals, you shouln'dt use the  both option unless you know how it works

[vazperen]

Yes, that's what I thought...thanks!