Direct relationship between two fact tables
"Direct relationship between two fact tables" is one of the modeling checks Auditabi runs on a Power BI semantic model. n relationship(s) link two fact tables directly. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Route the relationship through a conformed dimension (customer, product, date) instead.
What is detected
n relationship(s) link two fact tables directly. Facts should only relate through shared dimensions; direct joins create ambiguous paths and wrong totals.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Route the relationship through a conformed dimension (customer, product, date) instead.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.