DAXReliabilityLow
Text compared with an empty string
"Text compared with an empty string" is one of the reliability checks Auditabi runs on a Power BI semantic model. n expression(s) compare a column with "". It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Test with ISBLANK, or normalise empty strings to BLANK in Power Query.
What is detected
n expression(s) compare a column with "". In Tabular an empty string and BLANK are not the same value, so rows that look empty in the report are not matched.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Test with ISBLANK, or normalise empty strings to BLANK in Power Query.
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