Wildcard match values based on lookup from separate table and show in Visual

[sscanlon]

Hi, looked around for few days and have not found answer, hoping someone can help? 

I have a table let's call it "MAIN", it has all the data like part number, description, revenue, gp and more. 

In Description are long text strings and in the start or middle somewhere are product names, let's say Arista or Meraki etc. 

I would really like to have a table visual that shows the values from another table I create called "MODELS" but lookup each of those values in the description column in the other table, and show revenue and gp etc. 

The MODELS table looks like this: 

 

The visual I have currently that feeds from MAIN table looks like this: 

 

I would love to show a visual that has matches the DESCRIPTION above *Arista* WHERE Group = Network then show Revenue and GP totals for all matches of *Arista*, and do that for anything in that Table all the way down, if I add something to the table then it also shows the revenue / gp. 

Is this possible? Hoping I am describing this correctly? 

Not sure if this is a Measure or need to do something on Query Editor side?

Thank you!

[darentengmfs · Accepted solution]

Hi @sscanlon 

I've found this thread which I think is close to what you are looking for.

https://community.powerbi.com/t5/Desktop/Wildcard-matching-amp-returning-a-value/td-p/470276

[sscanlon]

Thank you! that was perfect, copied the logic and was able to do what I wanted, thank you!!