Find what values exist in Col1 where in multiple rows, each row with different condition met in Col2

[Vaiden]

Hey Everyone,

I am trying to do something extreamly specific and not sure if its even possible within Power BI. I have a table with users and intrest, looks similar to the image below.

By default with PowerBI if I use a slicer to find where intrest is sports and hiking it would return back any row were the intrest field had either sports or hiking as the value as shown below.

What I am trying to do is find what users have intrest in both sports AND hiking, and I am strugleing to find a way to do this. I assume I need to compair each row to itself to find where the user exist mutliple times and has both intrest insted of just one of the two specified. With the example table this would be the results I want to see:

Is there a way to filter the table like this? Thank you for your time!

[mahenkj2]

Hi @Vaiden 

You can make it fully dynamic here:

https://drive.google.com/file/d/1cWuBxA49pqco_I8zrhCFeXDHV0fVuRuM/view?usp=sharing

Hope it helps.

[mahenkj2]

Hi @Vaiden 

Its possible by few ways at least.

One ways, is kind of grouping by Users, and if count is more than once in the table, then we can filter those. 

for example, 

Counts = CALCULATE(COUNTROWS('Table'),ALL('Table'[Interest]))

and in the visual level filter, apply filter for these counts >1.

Hope it helps.