LOOKUPVALUE Blank with Report

[Anonymous]

 am using LOOKUPVALUE to find who owners are in a ticketing system based on information we draw from a report.  The LOOKUP DAX is Below that I am using and some sample data. The issue is that one of the cells contain multiple names where only one of those, even separated by commas, are returning blank. What other options do I have to recieve the correct Result?

RES7 = IF(SELECTEDVALUE('IS Service Request  - Data List'[Home Team])="Apps North America",LOOKUPVALUE('Home Team Owners 3'[Owners],'Home Team Owners 3'[Owners],SELECTEDVALUE('IS Service Request  - Data List'[Assignments])),BLANK())

Columns with Data

Home Team                             Assignments

Apps North America               Dale Durham, Joe Hancock, Mike nunley

Apps North America               Steve Romano

Apps North America               Marvin Taylor

Columns with Awnsers

Owners

Dale Durham

Marvin Taylor

Steve Romano

Results

BLANK()              -------> How do I get Dale Durham to show up here?

Steve Romano

Marvin Taylor

Any Help on this would be great. I'm not the best programmer.

[v-piga-msft]

Hi @Anonymous,

am using LOOKUPVALUE to find who owners are in a ticketing system based on information we draw from a report.  The LOOKUP DAX is Below that I am using and some sample data. The issue is that one of the cells contain multiple names where only one of those, even separated by commas, are returning blank. What other options do I have to recieve the correct Result?

---

LOOKUPVALUE is not suitable for your scenario, I suggest you may try with Search function or Find Funtion.

Best Regards, 

Cherry

[Anonymous]

Since I am using a column (Owners) to find the names within all of the cells. This would not work since the functions that you suggested only search for the parameters of specific word(s) or phrases and return them.

[Anonymous · Accepted solution]

I split the column data with a delimiter as a comma and over 10 Columns. Then I used a measure to reconcile the data and grab the correct Answer.

Thank you for all your help.

Sincerely,

Nick Patel