cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ovonel
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…

ovonel_0-1626903684701.png

 

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??

2 REPLIES 2
v-jayw-msft
Community Support
Community Support

Hi @ovonel ,

 

Do you have a relationship between fact table and dimension2?

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Greg_Deckler
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

Announcements
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!