Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Lookupvalue not working between 2 tables

Hi all   I am doing a lookup calcualted column, but doesn't work   Basically I have a table called 'Master Plant & Product' that has to xlooup its values on another table called 'SKU by line - Of...
Need Help
Show and Tell
  • KNP's avatar
    KNP
    4 years ago

    Try this instead...

    IF('Master Plant & Product'[Merged Plant & Product] IN DISTINCT('SKU by line - Official'[Merged Plant & Product]), 1,0)

     

    I may have typo'd your column names so double check those.

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
4 years ago

Wow KNP 

 

It worked! so the distinct in your dax basically converted the duplicated values to unique ones correct?

 

Thank you so much 🙂

KNP's avatar
KNP
Icon for Super User rankSuper User
4 years ago

It just gets the unique values of that column from the SKU table to compare with the Master table. So not to compare every row. 

At least, that's how I understand it to work.

 

Glad I could help, especially since my DAX knowledge is a work in progress. 😁

  • o59393's avatar
    o59393
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Thank you so much KNP 

     

    I guess the duplicate values on the SKU table were making noise and couldn't return the value.

     

    Thanks!