topic Re: Return multiple values from lookup in DAX Commands and Tips

Return multiple values from lookup

AndyJ001 — Wed, 19 Jul 2023 09:45:02 GMT

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?

Re: Return multiple values from lookup

baghdadi62 — Wed, 19 Jul 2023 11:06:04 GMT

Hi,

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

then:

Re: Return multiple values from lookup

AndyJ001 — Wed, 19 Jul 2023 11:23:22 GMT

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

Re: Return multiple values from lookup

baghdadi62 — Wed, 19 Jul 2023 11:34:51 GMT

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

Re: Return multiple values from lookup

AndyJ001 — Wed, 19 Jul 2023 11:46:43 GMT

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.

Re: Return multiple values from lookup

baghdadi62 — Wed, 19 Jul 2023 12:04:25 GMT

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

Issues[IssueLinks.LINKED_ISSUE_KEY]=Issues[IssueLinks.LINKED_ISSUE_KEY]

Re: Return multiple values from lookup

AndyJ001 — Wed, 19 Jul 2023 12:26:53 GMT

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.

Re: Return multiple values from lookup

baghdadi62 — Wed, 19 Jul 2023 12:53:50 GMT

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