Forum Discussion

o59393's avatar
o59393
Post 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
Post Prodigy
4 years ago

Hi KNP 

 

Look at the error after using related:

 

 

 

Strangely I do have a relationship.

 

Any idea?

 

Thanks.

KNP's avatar
KNP
Super User
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
    Post 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
      Super 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
        Post 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!