Unit Lookup for a string of values

[ranis1227]

Hello,

I am trying to do a unit lookup based on a string of text values below.  

For example, if I wanted to do a slicer visual search on 10A, I want to see all the pathways that have 10A in it regardless of position in the pathway:

I tried SEARCH,FIND,LOOKUP to no avail.  Any help will be greatly appreciated. 

[SpartaBI · Accepted solution]

@ranis1227 I just gave a similar answer in this post:
https://community.powerbi.com/t5/Desktop/Extract-unique-strings-in-column-and-group-together-count-a...
filter by string.pbix

      

Showcase Report – Contoso By SpartaBI

[ranis1227]

Thank you SpartaBI. This is very helpful. 

[SpartaBI]

@ranis1227 my pleasure 🙂
Hey, check out my showcase report - got some high level stuff there 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂