filtering one table based on if multiple values exist in another table

[powerbinoob457]

I'm have two tables in my data set

manager	user 1
manager	user 2
manager 2	user 3
manager 2	user 4
manager 2	user 5

and 

user 1	a
user 2	b
user 3	a
user 4	a
user 5	a

I need to create a report view that will show me the Manager value in the first table, only for values where i have multiple options in the second table.

So in the case of the tables above i want to see the value for manager because user1 and user 2 have values a and b.

I don't care about Manager 2 as their associated users all have value a.

I already created a table relationship using the user column in the first table as the primary key.

I'm not really sure how to ask the question for a google search on this one so hopefully someone can point me in the right direction.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my solution from here.

Hope this helps.

[powerbinoob457]

Thanks Ashish your solution seems to work best for my needs.

[Ashish_Mathur]

You are welcome.

[v-yuezhe-msft]

@powerbinoob457,

Please review the calculations in the PBIX file below.

https://1drv.ms/u/s!AhsotbnGu1NojkJOHcLiVIZAgsu7


Regards,
Lydia