Forum Discussion
Cross filtering multible fact tables using shared dimensions
I have a sample problem below thats a simplified version of a model im working on.
The First fact table has course results.
The second fact table has subject results.
Both tables have student, course and year, so they can be linked by these dimensions.
When i select a course and status of failed, I want to see the subjects under that course and their results.
ProblemI am facing is cross filter cannot be applied to all relationships. once i try to set a second relationship to a crossfilter status of "Both" i get the error " the relationship you're creating lets you filter Fact1 by fact2, but power BI Desktop allos only one filtering path between tables in the data model....."
A sample data model is at this
Screenshot of the model is shown below. Appreciate any pointers in the right direction.
2 Replies
I faced a similar issue when I try to setup cross filtering for the second relatioship but only one cross filtering relationship was sufficient for my model though. I was able to filter data from both fact tables with that. I am not sure if it is really necessary to set up cross filtering for all the relationships we have in our model between facts and dimensions. Experts can shed some light on that.
defo needed here, your problem is very different.
lets say i have one bar chart (chart A) showing count of passes and fails in each course.I have a table (table B) that shows subjects and results.
I want users to be able to click on chart A and have the results in table B change.Users also need to be able to do this based on course, or year.
Without multiple cross filtered relationships, this cant work, at least in the current model design.
