DAXDAX QualityLow
CONCATENATEX without an explicit order
"CONCATENATEX without an explicit order" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n measure(s) build a list with CONCATENATEX without an order-by argument. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Pass the sort column and direction so the label is stable.
What is detected
n measure(s) build a list with CONCATENATEX without an order-by argument. The order then depends on the storage engine and can change between two refreshes of the same report.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Pass the sort column and direction so the label is stable.
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