TREATAS with a different number of columns
"TREATAS with a different number of columns" is one of the reliability checks Auditabi runs on a Power BI semantic model. n expression(s) call TREATAS with a table expression and a list of target columns that do not line up. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Make sure the table expression returns exactly one column per target column, in the same order.
What is detected
n expression(s) call TREATAS with a table expression and a list of target columns that do not line up. The function silently applies the filter to the columns it can match and ignores the rest.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Make sure the table expression returns exactly one column per target column, in the same order.
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