Join performed in DAX
"Join performed in DAX" is one of the performance checks Auditabi runs on a Power BI semantic model. n expression(s) join tables in DAX with NATURALLEFTOUTERJOIN, NATURALINNERJOIN or GENERATE. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Join in Power Query or the warehouse and expose the result as a table.
What is detected
n expression(s) join tables in DAX with NATURALLEFTOUTERJOIN, NATURALINNERJOIN or GENERATE. Joins belong upstream: in DAX they are recomputed at every query and cannot be folded.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Join in Power Query or the warehouse and expose the result as a table.
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