In Power BI, there are multiple ways of searching for a text term inside a text field, you can use Power Query for doing this operation or calculations in DAX. In this video, I'll explain some functions in DAX that you can use to do this calculation. Most of these functions can be used inside a measure for dynamic calculation. In this video, you will learn about a few of DAX functions that deal with search a text term in a text field.
Read more details from my blog post, the link to download the AdventureWorks file, plus links to study more:
https://radacad.com/find-a-text-term-...