Dimension joined to another dimension (snowflake)
"Dimension joined to another dimension (snowflake)" is one of the modeling checks Auditabi runs on a Power BI semantic model. n dimension(s) are filtered by another dimension instead of standing on their own. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Flatten the attributes into the dimension in Power Query, so the fact reaches every attribute in one hop.
What is detected
n dimension(s) are filtered by another dimension instead of standing on their own. Every extra hop costs a join at query time and makes the filter path harder to predict.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Flatten the attributes into the dimension in Power Query, so the fact reaches every attribute in one hop.
Reference
Kimball: dimensional modelling
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.