Forum Discussion
Post PatronFilter dimension tables in Star schema?
First I had a flat table and when I filtered in the filters pane, it would also filter out the other 'dimension columns'.
Now I made it into a star schema and when I filter 1 dimension in the filters pane, it doesn't filter the other dimensions. It shows all values in that column. I understand why, but how can I achieve this?
Note: I have multiple fact tables that connect to these same dimension tables. Below is 1 of the star schemas.
8 Replies
Hi richard-powerbi ,
If I understood you correctly you should get the relationships both sided.
Let me know if that's what you wanted and if it worked, if so mark as solution.
BR,
DR
richard-powerbiHi Anonymous
I know this is a solution, but I always read you should avoid bidirectional relationships for performance and aggregation risks. This way I'll get many bidirectional relationships. Is there another solution? Or how can I check if it messes up my aggregations? I know it happens if there is more than one path to follow, but this is very hard to analyze in a big model....
Did you ever find a solution for this? I've read much about how one can solve this if using slicers, but nothing about how to solve it when using the filter pane. I've tried many model options and nothing seems to work. Bi-directional ends up with circular references; I'm never working with M:M relationships and don't intend to; etc.
