Filter rows based on 2 related tables

[Danial26]

Hi There,

So I have 2 tables with the same unique ID. Both tables has a column called department name. The Business logic behind both tables are as below:

Table B can have a value of Department 1 but have have 2 different Department Value in Table A. 

Table A can have a value of Department 1 but Have no Values at all in Table B

Table A:

ID	Department Name
1	Dep1
2	Dep2
3	Dep3
4	Dep1

Table B:

ID	Department Name
1	Dep1
2	Dep1
3	Dep3

So I would like to create a table visuals in PowerBI that has filter out the row of Filter A Based on the column from Table B that has a value of Dep1 and also Value of Dep1 In Table A

ID (From Table A)	Department Name
1	Dep1
2	Dep2
4	Dep1

[amitchandak]

@Danial26 , Create a slicer based on Table A dept

Create a measure and add it to the visual having column from table 2 or use it as a visual level filter

measure = calculate(countrows(Table2), filter(Table2, Table2[dept] in values(Table1[Dept]) ) )

[Danial26]

Hi @amitchandak , I am so sorry but I was editing my post and before I managed to post it, you manage to answer it. There is another condition that I have added. Do you think it will work with the added conditions? so sorry again as I am new to the community