Surrogate key filtered by value
"Surrogate key filtered by value" is one of the maintainability checks Auditabi runs on a Power BI semantic model. n measure(s) filter a surrogate key against a literal number. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Filter on the business attribute (the code or the name), never on the surrogate key.
What is detected
n measure(s) filter a surrogate key against a literal number. Keys are regenerated by the ETL, so the measure silently starts pointing at a different member.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Filter on the business attribute (the code or the name), never on the surrogate key.
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