Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Return multiple values from lookup

Does anyone know if there is a way to lookup a value in a table and return multiple values split by comma in another column?


Resolver III
Resolver III


if there is no relationship between two tables you should do it on this way:


tbl imagetbl image




View solution in original post

Resolver III
Resolver III

You're welcome. It seems that a conditional statement is not defined in your Filter() function and only the field name has been mentioned.

With conditionWith condition


Without conditionWithout condition

Thank you again for your help, this is now what i have 
Column = CONCATENATEX(FILTER(Issues,Issues[IssueLinks.LINKED_ISSUE_KEY]=Issues[IssueLinks.LINKED_ISSUE_KEY] ,Issues[Organizations_14102.Organizations],",")

what i am trying to do is bring back multiple Organizations against the linked issue key so like using lookupvalue to bring back multiple values split by a comma in one column.

Second parameter of Filter() function is not correct, I see both side of the equal sign are the same.


@baghdadi62  i now haver this 

Column = CONCATENATEX(FILTER(Issues,Issues[ISSUE_ID] = Issues[IssueLinks.LINKED_ISSUE_ID]),Issues[Organizations_14102.Organizations])
this now is bringing back only blanks, what im trying to achieve is against each linked issue id there will be multiple Organizations_14102.Organizations so i need a similar function to lookupvalue but to bring back multiple values in one column split by a comma so using something a bit like this 
LOOKUPVALUE(Issues[Organizations_14102.Organizations],Issues[ISSUE_KEY],Issues[IssueLinks.LINKED_ISSUE_KEY]) but to bring back multiple results.

It seems that both side of the equal sign are columns of one table that not correct.

Resolver III
Resolver III


if there is no relationship between two tables you should do it on this way:


tbl imagetbl image




Hi @baghdadi62 thank you for your reply, this is what i have 

Column = CONCATENATEX(FILTER(Issues,Issues[IssueLinks.LINKED_ISSUE_KEY]),Issues[Organizations_14102.Organizations],",")
Its now telling me i cant convert the value to true or false, any ideas? both columns are in the same data set but it should be returning many Organizations against a linked key but it doesnt seem to be working, any ideas?
thank you again for your help

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors