Facts combined with UNION in DAX
"Facts combined with UNION in DAX" is one of the modeling checks Auditabi runs on a Power BI semantic model. n calculated table(s) union fact tables. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Append the sources in Power Query (column names are matched) or in the warehouse.
What is detected
n calculated table(s) union fact tables. Column mapping is positional, so a column added to one side silently shifts the data, and the union is rebuilt at every refresh.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Append the sources in Power Query (column names are matched) or in the warehouse.
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