cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alenashkel
Helper III
Helper III

COUNT doesn't change with filter

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

1 ACCEPTED SOLUTION
az38
Super User II
Super User II

Hi @alenashkel 

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 🙂


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

3 REPLIES 3
az38
Super User II
Super User II

Hi @alenashkel 

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 🙂


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

@az38  @amitchandak 

That was it!

 

Thank you for the help, so simple 🙂

amitchandak
Super User IV
Super User IV

@alenashkel , 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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors