Using lookupvalue error because of duplicates

[Sgb1201]

Hey, 

I'm using a lookupvalue function in one of my columns to get values from another table in my dataset, but I'm getting an error. I think this is because of duplicates in the item value collumn: 

I've tried removing duplicates in the query editor, but it leaves the above "duplicates", possibly because of the two different values in the third column. Is there an easy way (either in DAX or M) to make it simply choose the first value (in the third column) and delete the second as it is redundant -- and thereby removing the duplicate item values (first column?) 

Best regards, 
Sgb

[Sgb1201]

@amitchandak , I got it to work with the first part (Maxx(filter(Table2, Table1[ID] = Table2 [ID] ), Table2[Column])), where the Table2[Column] is the first column (item number), right? 

The second part does not work -- what does it do exactly? 

Either way, it seems to work correctly without the second part anyways, thanks alot for the help! 

[amitchandak · Accepted solution]

@Sgb1201 , You can try like , a new column in table 1

Maxx(filter(Table2, Table1[ID] = Table2 [ID] ), Table2[Column])

Sumx(filter(Table2, Table1[ID] = Table2 [ID] ), Table2[Value])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8