When a measure fails validation, the editor shows a diagnostic pointing at the
exact position in the expression, with one of these codes. Errors block
saving; warnings don’t.
| Code |
Meaning |
| SQX001 |
syntax error |
| SQX002 |
unknown function |
| SQX003 |
unknown table or column |
| SQX004 |
unknown measure |
| SQX005 |
circular measure dependency |
| SQX006 |
type incompatibility |
| SQX007 |
Fixed argument shape |
| SQX008 |
modifier outside Calculate |
| SQX009 |
nested aggregation |
| SQX010 |
unsupported on this database |
| SQX011 |
duplicate measure name |
| SQX012 |
unbound identifier |
| SQX013 |
wrong arguments |
| SQX014 |
row-level expression in a measure |
| SQX015 |
non-additive accumulation |
| Code |
Meaning |
| SQXW01 |
shadowed Let binding |
| SQXW02 |
measure named after a function |
- SQX012 — a bare name the analyzer can’t
place. Almost always a missing
Table. prefix or [brackets].
- SQX014 — row-level logic in a measure.
The fix is a calculated field; the message says
so too.