Filtering doesn't work

[Ramesh-iTalent]

Hi, I'm new to Powerbi, and I'm developing a board. I have three tables:

Now, I want to find a count of emp ids that belong to a particular city in Table 2. For some reason the city filter does not work in Table 1. Can someone help me with this kind of problem? Happy to explain more in case I'm not clear on my question.

[v-juanli-msft]

Hi @Ramesh-iTalent 

Change filter direction between table1 and table3 with both direction.

Then use distinctcount DAX funtion.

Best Regards

Maggie

[amitchandak]

@Ramesh-iTalent , You need to count from table 3 and Table 1 and Table 2 should be 1-M relationship with Table 3

Distinctcount(Table3[emp id])

[Mariusz · Accepted solution]

Hi @Ramesh-iTalent 

it should work If you count emp id in tbl 3, like 

Measure 2 = 
DISTINCTCOUNT( 'Table3'[EmployeeID] )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn