Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

lookupValue in the same table

Hi All,   I am trying to populate a column (Manager ID) using the Lookupvalue but getting error mesage that says "A table of multiple values was supplied where a single value was expected."...follo...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • mauriciosotero's avatar
    mauriciosotero
    6 years ago

    Hi,

     

    You can use this DAX:

     

    Manager ID = LOOKUPVALUE('OrgChart_Raw'[Employee ID],'OrgChart_Raw'[Name],'OrgChart_Raw'[Manager Name])

     

    If this helps, I apreciate you give a kudo and mark as the solution. Thanks

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Anonymous -

 

Anonymous wrote:

 

... says "A table of multiple values was supplied where a single value was expected."...

 

From https://dax.guide/lookupvalue/: If multiple rows match the search values and in all cases Result_Column values are identical then that value is returned. However, if Result_Column returns different values an error is returned.

 

If you are able to create your table with that constraint LOOKUPVALUE works fine within the same table.