SQX014 — Row-level expression in a measure
Severity: error — blocks saving until fixed.
What happened
Section titled “What happened”A bare column appears outside the places columns are allowed (aggregation arguments, Calculate predicates, Fixed/modifier arguments, column-typed signature parameters). A measure must reduce to one value per group — SquareX has no row context.
How to fix it
Section titled “How to fix it”Row-level logic like Switch(Sales.Segment, …) belongs in a calculated field; aggregate its result in the measure.
Example
Section titled “Example”// fails: bare column at measure levelSegmentLabel := Switch(Sales.Segment, "A", "Alpha", "Other")// row logic → calculated field; the measure aggregates it