Forum Discussion
richard-powerbi
Post Patron
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 filter...
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....I don't think so unless you make some common table that associates all the foreign keys from those all tables.
BR,
DR
- richard-powerbiYea that might be a better solution. I'll accept it as a solution once I've implemented it.