Forum Discussion
jayanthan
6 years agoHelper III
Filter Data | Between dimension tables
Hi there, I have an issue of filtering data between master tables. For an instance, there is a relationship between sales, organization table, and product table. when I filter the organization, t...
ibarrau
6 years agoSuper User
Hi. I would suggest you to keep the model with single relationships and follow this practise:
https://blog.ladataweb.com.ar/post/185907335292/datamodeling-sincronizar-filtros-entre
You can get the dimension filtered by each other with their matches inside a fact. You need a measure to filter it. The post contains a more detail explanation.
You can also check this user that had the same issue:
Regards,