Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

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

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!

Impactful Individual
Impactful Individual

Hi @Vaiden 


You can make it fully dynamic here:




Hope it helps.

Impactful Individual
Impactful Individual

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.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors