one of the columns must have unique values

[Pat_Da_Cat]

Hi,

So I have a lookup table consisting of two columns (Component #, Description) with 220 rows of data that i'm trying to create a relationship with my main dataset, however I keep getting the following error message:

I checked the lookup table for duplicates and there are none. Does anyone have any ideas?

Thanks for reading.

[Zubair_Muhammad · Accepted solution]

HI @Pat_Da_Cat

Try adding this Column in your MinVit table to identify if there are any Duplicate Components...

CalculatedColumn =
IF (
    CALCULATE ( COUNTROWS ( MinVit ), ALLEXCEPT ( MinVit, MinVit[Components] ) ) > 1,
    "Duplicate"
)

[Pat_Da_Cat]

Thanks! I missed one double entry.