Forum Discussion
Data Modeling
- Anonymous3 months ago
Hi VK-Vishnu ,
If you have already implemented a star schema and the common slicers are still not filtering all visuals correctly, then the issue may be related to the relationship configuration rather than the schema design itself. In a star schema, shared dimension tables should filter all connected fact tables through active one-to-many relationships.
Could you please share a screenshot or diagram of your current data model, including the relationships between the 3 fact tables and 4 dimension tables? Also, please confirm whether the slicers are built from dimension tables and whether all relationships are active.
This will help identify whether the issue is related to relationship paths, filter propagation, or model design.
Keep your dim tables as single tables. Do not duplicate them. Each fact table connects to the shared dims through individual relationships
Dim1 --- Fact1 --- Dim2
|
Fact2 --- Dim3
|
Dim4
mark only one relationship as active between any two tables, use USERELATIONSHIP in DAX for inactive ones.