filter in PowerBI, where a customer can be in more than one category

[legenda689]

Hello everyone,
I need to create a filter in PowerBI, where a customer can be in more than one category.
I have a dataset of clients who are looking for jobs by categories and I need to filter by quarter (3 months). For example, Mark can be looking for a job in accounting in Q2 and Q3 so simple if statement won't work (as it will Flag him as only Q2 )
And in my graph when I select a filter for quarts I will need Mark to be counted in both Q2 and Q3
I hope I explained it properly.

I want my final BI table to be something like this

I'm really looking for your suggestions

Thanks

[Uzi2019]

Hi @legenda689 

Can you provide the proper data sample. like all the columns and expected output??

some of your columns are missing please provide the sample data.