Having a denormalized table from multiple tables in a star schema

[klehar]

Hi,

I have 3 tables related to Student. You can see the model in the attachment.

All I want to show is show Student ID in the very first column from the first table(Dim Table)

Then Column2 from Table 2 (Fact Table) (default aggregation : sum)

Then Column3 from Table 3 (Fact Table) (default aggregation : sum)

Whenever I try to do this, I get wierd errors. Not sure how I can resolve the same.

Changing relationships to m:m doesn't look like a good solution

Hers the pbix link

[Anonymous · Accepted solution]

Hi @klehar ,

It can be solved by changing the direction of relationship.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Your relationships are wrong in both tables.  You'll understand from the screenshot

[CNENFRNL]

As far as I'm concern, I agree on your data model. It's inevitable to run into issues of filter propagation, say, when you slice Donation[Year], the filter can't propagate to 'Student Subject' table in a natural way. The solution I recommend is to make the best of Expanded Table.

https://www.sqlbi.com/articles/expanded-tables-in-dax/

[klehar]

Expanded tables have been confusing to me. Can you explain how I can make use of in this case.