Forum Discussion
Linking date dimension to multiple tables (dates)
- Anonymous6 years ago
You should NOT link dates from fact to fact (action to book).
The direction of the relationship should be monodirectional whenever possible (and I don't see a valid reason to have them bi in this model).
Remove that relationship between the Action and the Clarity OR leave it inactive and enable it when needed using USERELATIONSHIP.Then re-think your model based on the business needs. Do you start from Clarity to filter actions? Use a metric to obtain your data and enable the relationship when needed.
Cases like this require a careful planning of your business needs or you end up in an unmanageable model (and based on what I see you started with the wrong foot).
Take a basic tutorial on data modeling and relationships in PowerBI. They're not simply arrows with filters, they're fundamental.
Created a better datamodel, now its working
Hello Chris,
I wonder how you could join more than one table to the date table without an indirect relationship. I have tried similar and I have an indirect relationship. I would appreciate your insight.
Thanks