MIN or MAX applied to a key column
"MIN or MAX applied to a key column" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n measure(s) aggregate a surrogate key with MIN or MAX. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Aggregate the attribute the user cares about, or use SELECTEDVALUE on the descriptive column.
What is detected
n measure(s) aggregate a surrogate key with MIN or MAX. The result is a technical identifier shown as a number to business users, and it changes whenever the keys are regenerated.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Aggregate the attribute the user cares about, or use SELECTEDVALUE on the descriptive column.
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