Creating a filtered table via a contains function

Question

Hello,&nbsp;I have an urgent question for which I could really use some help.&nbsp;Basically, I have a huge amount of data pulling in from an external resource, which is great.&nbsp;I have say, 3000 companies and for them, investor data.&nbsp;Company &nbsp; Investor&nbsp;Apple &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rafa &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Microsoft &nbsp; &nbsp; &nbsp; BillAcer &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JohnTito &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Rafa, NikoLogitech &nbsp; &nbsp; &nbsp; &nbsp; Dino&nbsp;&nbsp;Then, I have a seperate list of 'key investors. Lets say this list is1) Rafa2) Bill&nbsp;&nbsp;How do I get to a table that shows me the companies filtered by the investors in this list of 2 priority people as above?&nbsp;Company &nbsp; &nbsp; Investor&nbsp;Apple &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RafaMicrosoft &nbsp; &nbsp; &nbsp; BillTito &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Rafa, Niko&nbsp;I think it has something to do with the contains function,...but really don't get this at all. Any help would be much appreciated - on a strict deadline for this task.&nbsp;&nbsp;&nbsp;

mfelix · Answer

Hi&nbsp;cartman21,&nbsp;I'm assuming the key investor list is in a separate table, if so just do a relationship between the two table and use the investor key table in your visual to have the companies per user and filter the blanks out of the key investor column.&nbsp;&nbsp;Regards,MFelix&nbsp;&nbsp;&nbsp;&nbsp;

cartman21 · Answer

Hello, thanks for taking the time to respond!

The problem is that the list is of KEY investors is like this:

But the data i am being fed has stuff like this:

So the method you provide sadly does not work due to this reason.

Any ideas?

cartman21 · Answer

Anyone?

mfelix · Answer

Hi&nbsp;cartman21,&nbsp;Not abble to see this in the afternoon will try to get back to you tomorrow morning.&nbsp;regardsMFelix

v-huizhn-msft · Answer

Hi&nbsp;cartman21,If the investors name are in fixed location in your resource table. &nbsp;In Query Edit navigator, you split the column into separate columns by delimiter(blank), get the investors column like the example you given above, then you can the solution posted by&nbsp;MFelix.In addition, from the screenshot below, the column is the investors or company fields? Could you please give more details, so that we can post the solution which is close to what you want.Best Regards,Angelia

Forum Discussion

Creating a filtered table via a contains function

8 Replies

Related content

Creating Measure with Filter against column that contains lists

Contain Word

Creating a Date Filter in Power BI

Filter contains

Visual calculation- Contain