Forum Discussion
Power BI Data Modeling Question
Super UserHi RajiKarthik
1:Yes, the approach is correct. Keeping the Student and Course facts and using shared dimensions instead joining two fact tables.
2.1:Blanks usually indicate null dimension keys in the source. You can check the relationship and key columns. If totals match, the blanks represent records without a dimension value.
2.2:Most likely relationship or filter-direction issue. A shared Dim Department can show Healthcare Management in the slicer but if the matrix combines School + Department and the student fact is not correctly filtered through those dimensions then the combination might disappear.
Please check these
Relationship between Dim Department - Student fact. Relationship cardinality and cross-filter direction. Whether Healthcare Management has a valid matching department key in the Student fact. Whether the matrix is using both dimensions from the same model and the DAX measures
Thank you for your response. I think I found the issue, but still not sure about the fix. I created a parameter that includes metrics from both data sources. If I use that parameter to change the metric, the Student -> Healthcare management disappears. Instead, I tried validating by just placing the count of students (same measure in parameter), and it works. I need to figure out why the parameter is behaving strangely!
