Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

why filter applied on dimension1, impacts dimension2 (which isn't connected)

I have a model in SSAS.


A fact table and 2 dims.



It was my understanding, that, we use the relationships is to filter…



I have a fact table and 2 dimensions… there is no relationship between the dimensions.


Whenever I work on a pbix and filter the dimension1, it correctly filters the fact table… but if I am playing around with the dimensions without the fact, also the data gets filtered, how is this possible?


That is, if I select country=xyz in dimension1, then that will also filter dimension2… How come??

Community Support
Community Support

Hi @ovonel ,


Do you have a relationship between fact table and dimension2?


Best Regards,


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User
Super User

@ovonel My first expectation is that your cross filter direction is set to Both instead of Single but not enough information to be certain.

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!