Filter out 1 "person" from a string with multiple "person"

[TcT85]

I need to make a drill down function were I get data for each person.

I have a excel sheet with a list with tasks and people responsible on solving the task. so for one task there can be 1 people or multiple people.

What I need is to be able to drill down for 1 people.

In the current situation when i drill down on "Responsible" for example "BBU" i will not get information from BBU/MLB.

I need to be able to drill down on a certain people that will show all "Project Nr" that contains BBU in Responsible.

Is the only solution for this Delimiter or is there any other better solutions that will not duplicate my data?

[TcT85]

Hi, @v-easonf-msft 

Thank you very much this was exactly what I was looking for

[Ashish_Mathur]

Hi,

Expand the filer pane and apply a 'Contains' filter there.

[v-easonf-msft · Accepted solution]

Hi, @TcT85 

You need create/enter a seperate table showing all person in 'Responsible'

Then you can apply a filter measure to this table visual filter pane.

filter = 
var a=IF(CONTAINSSTRING(MAX(Table1[Responsible]),MAX(Table2[Responsible])),1,0)
return IF(ISFILTERED(Table2[Responsible]),a,1)

If I misunderstood, please share more details.

Best Regards,
Community Support Team _ Eason