RELATEDTABLE on a table with no relationship
"RELATEDTABLE on a table with no relationship" is one of the reliability checks Auditabi runs on a Power BI semantic model. n expression(s) call RELATEDTABLE on a table that is not related to the current one. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Create the relationship, or use CALCULATETABLE with an explicit filter.
What is detected
n expression(s) call RELATEDTABLE on a table that is not related to the current one. The function returns the whole table instead of the related rows, so counts and sums are computed over everything.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Create the relationship, or use CALCULATETABLE with an explicit filter.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.
More DAX checks
- Arithmetic or comparison on a measure that returns text
- Measure returning text in one branch and a number in another
- Share denominator clears a fact-table column instead of the dimension
- "Previous period" window overlaps the current one
- Percentage label built without ×100
- Percentages and amounts summed together