Forum Discussion
Linking date dimension to multiple tables (dates)
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.
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
Now this one looks much better :-)
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
