Forum Discussion
Trouble with Cross Direction Ambiguity with Date Table
Hi,
I'm having trouble with ambiguity in the relationships to my date table in my data model. I have a quite a complex data model that includes data from schools on student behaviour. (see image below).
I've created a few custom columns in my student table that give each each student a number of hours spent in school, total number of behaviour points (from the student behaviour table) and total number of achievement points (from the student achievement table). I then have a custom column which shows the number of behaviour/achievement points accrued per hour spent in school for each student.
I'm attempting to display a card visual which shows the number of behaviour/achievement point per hour for each month using my date table for time intelligence however because my date table links to both the achievement and the behaviour tables I can only cross filter my student table by one of these tables.
Any ideas on how I can get around this would be welcome, have I just designed my data model wrong?
Hi MarkClipsham ,
For the relationship, recommend you create the star schema instead of circle schema, so you may delete the secondary relationships among these tables, and change the Cross filter direction of relationships among the these tables above from Single to Both , which will take these tables treated as a single table.
You can learn more about relationship :https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
v-xicaiCommunity Support
Hi MarkClipsham ,
For the relationship, recommend you create the star schema instead of circle schema, so you may delete the secondary relationships among these tables, and change the Cross filter direction of relationships among the these tables above from Single to Both , which will take these tables treated as a single table.
You can learn more about relationship :https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.