Lookupvalue giving error A table of multiple values was supplied where a single value was expected

[binayjethwa]

Hi,

I have multiple tables in my model , but i need few columns from other tables in my current table. 

If i model those tables , i will have one to many relationship but i will have a one side for my main table and many with other tables , now since i want my data from other tables also i cannot get it since those other tables are not related and if i relate i will have many to many relationship.

So I tried to bring those required columns from other tables into current table using lookupvalue, but for some of the columns i am seeing "A table of multiple values was supplied where a single value was expected." error . 

Related dax will not work because i am creating columns in one side of table and it will not able to create it .

Can someone suggests how can i proceed further ,if i want to bring those columns into this table and surpass that error.

Thanks,

Binay  

[binayjethwa]

Hi @Anonymous

[Anonymous]

Hi Try this
LOOKUPVALUE('Table'[Column that you need],'Table1'[ID column which has unique],'Table'[ID column])

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[ryan_mayu]

@binayjethwa 

could you pls provide some sample data and expected output?

Lookupvalue can only return unique value, if there are multiple values, then we can't return multiple values in one cell. 

[binayjethwa]

Hi @ryan_mayu ,

i basically need to get the column from another table which doesn't have unique rows. Is it possible somehow ? 

[ryan_mayu]

pls provide some sample data and expected output. if there are multiple values, which one do you want to get? you need to have the logics.

[binayjethwa]

Hi @ryan_mayu ,

Basically this is my data model , all the data flows from HC table to other tables , Here i cannot map my GTE with 0% util since it will be many to many , so i thought instead of relationship, i can do a lookup and bring all columns to my HC table and use in the final output.

My final output is the list of columns coming from all these tables. Is there way we can achieve this.

[ryan_mayu]

could you pls provide some sample data and the expected output?