Business threshold written into the DAX
"Business threshold written into the DAX" is one of the maintainability checks Auditabi runs on a Power BI semantic model. n measure(s) compare against a literal business threshold (a target, a margin, a limit). It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Move the threshold into a parameter table or a disconnected slicer so the business can change it without a deployment.
What is detected
n measure(s) compare against a literal business threshold (a target, a margin, a limit). Changing it means editing a measure and republishing, and nobody outside the team can see the value that is applied.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Move the threshold into a parameter table or a disconnected slicer so the business can change it without a deployment.
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