COUNT doesn't change with filter

[Anonymous]

I have two tables, with a one to many relationship.

I have two filters, one from table 1 and the ther from table 2.

I also have a card with a count from table 1 (not a measure) 

When I filter table 1, the count changes, but when I filter table 2, nothing changes. (and it should) 

Anyone knows why this is happening? 

Thank you in advance

[az38 · Accepted solution]

Hi @Anonymous 

I believe you have one-directional relationships. you should optimize your data-model. more detailed answer is not possible due to limited information by you 🙂

[Anonymous]

@az38  @amitchandak 

That was it!

Thank you for the help, so simple 🙂

[amitchandak]

@Anonymous , In one to many single directional join. Many side table will not filter one side. make it bidirectional or

have a measure from many side table and in visual level filter check that this measure is not blank.