Filtering a name from a row of names

[AmazingRandom]

I am doing some training and learning in my PBI skills and I am stuck in this next step where I am trying to create a filter for a sequence of names. 

Here is how the column looks like:

Appearance

Owen, Tia, Stu, Matt, Arthur, Andy, James, David, ODY, Shane, Sid

Owen, Stu, Matt, Arthurt, Andy, James,Brendan, ODY, Shane

Owen, Stu, Matt, Arthurt, Andy, Brendan, ODY, Jody, Doug

Owen, Stu, Matt, Andy, James, Brendan, ODY, Shane, Jody, Doug

Owen, Matt, Arthur, Andy, James, Brendan, ODY, Shane, Jody, Doug

Owen, Stu, Matt, Arthur, Andy, Brendan, Shane, Doug, Brano, Jake

Owen, Stu, Matt, Andy, ODY, Shane, Doug, Will, Jake

Owen, Stu, Matt, Arthur, ODY, Shane, Doug, Will, Jake

How can I create a filter where I can select for example all rows where James attended? I know to us it sounds easy logically but I am struggling to find a way to create a measure for this

[amitchandak · Accepted solution]

@AmazingRandom , One is you can use text filter.

Second Split the column, using split by delimiter into rows and rhen you can filter.

Thrid is same but you split dimension not in table

Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2

[HamedM1125 · Accepted solution]

@AmazingRandom  

If your dataset is not complex then you can achieve this manually by the following method, else go by split column by delimeter method. 
Manual effort:
1. Create a separate column for each name to search the text:

Owen = IF(SEARCH("Owen",Tablee[Appearance],1,BLANK()) <> BLANK(),"Yes","No")
2. Create a final column If a name is available then mark it as Yes else No.

All availability = IF(Tablee[Owen] = "Yes" && Tablee[Arthur] = "Yes" && Tablee[James] = "Yes","Yes", "No")
3.  You can add the All availability column in a slicer and filter "Yes" if you need to find someone's presence in all the  rows.  

[Anonymous]

Hi @AmazingRandom ,

Did the users above help you? I agree with ThxAlot‘s solution.

If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.

If not, please provide a more detailed description, preferably some virtual sample data, and the expected results.

Best Regards,

Stephen Tao

[ThxAlot · Accepted solution]

If this question comes from your entry-level tutorial, you can now save your time by dumping away. Either the person who prepares the tutorial doesn't know what DAX is for, or it's used for learners who have already quite a bit of knowledge of PBI.

[HamedM1125 · Accepted solution]

@AmazingRandom  

If your dataset is not complex then you can achieve this manually by the following method, else go by split column by delimeter method. 
Manual effort:
1. Create a separate column for each name to search the text:

Owen = IF(SEARCH("Owen",Tablee[Appearance],1,BLANK()) <> BLANK(),"Yes","No")
2. Create a final column If a name is available then mark it as Yes else No.

All availability = IF(Tablee[Owen] = "Yes" && Tablee[Arthur] = "Yes" && Tablee[James] = "Yes","Yes", "No")
3.  You can add the All availability column in a slicer and filter "Yes" if you need to find someone's presence in all the  rows.  

[amitchandak · Accepted solution]

@AmazingRandom , One is you can use text filter.

Second Split the column, using split by delimiter into rows and rhen you can filter.

Thrid is same but you split dimension not in table

Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2