cross join in facts and dimension

1
votes

In the multidimensional cube, I have two facts (at different grain) named as : FactTestScore and Fact SubjectScore. These two facts share two dimensions- DimStudent and DimSubject. And FactTestScore has additional dimension of DimTest. I've deployed the cube without any error.

In the PowerBI to create report, when I have matrix table with Subject, Test, Student and their respective scores, the all tests are getting cross joined with all subjects. Can you please point out where I am making mistake? enter image description here

1
sql-serverpowerbissasdata-warehousemultidimensional-cube
Can you explain/show what this means in your case: it looks like there is cross join happening – Alexis Olson
I added additional explanation to the question. Hope that makes sense. – Nancy Drew
Are you using Power BI against an external multidimensional SSAS cube? Thats an unexpected configuration. Why not just do the modelling inside Power BI and leave the SSAS Multidimensional out of it – Nick.McDermaid
@NancyDrew you mentioned there is an issue with a Matrix visualization. Please provide the exact name of Data Column in the format 'Table Name'[Column Name] and the DAX of the measures you are using. – Seymour

1 Answers

0
votes

In Power BI, filtering across relationships can only propagate in the direction specified.

In your diagram, there is no path from one dimension table to another without going the "wrong way". In fact, it doesn't look like they can even filter the fact tables unless the notation is the reverse of what I'm accustomed to.