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

mauriciosotero's avatar
mauriciosotero
Resolver III
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

  • mraka9's avatar
    mraka9
    Helper III
    4 years ago

    Hi, I have a similar problem.
    I have empty rows in the "Manager Name" search column and need to find values only for those rows for which there is a name. I can't solve the problem in any way, but I get a notification: A table with more values is given when an individual value was expected.