SQX010 — Unsupported on this database or composition
What happened
Section titled “What happened”Either the source’s SQL dialect can’t run the function — e.g. Median or Percentile on MySQL, SQL Server, or BigQuery — or the expression composes context/time functions in a way the engine refuses to lower rather than guess at: a Fixed nested inside another Fixed, YTD/RollingSum or DateShift inside a Fixed body, a context function embedded in arithmetic under Calculate, a predicate or removal targeting a window’s own date axis, DateShift composed with a snapshot (LastNonEmpty/PeriodEndSnapshot pick a real date), a PeriodEndSnapshot whose chart doesn’t group by its date column at the same grain, or an ambiguous filter/removal overlap across nested Calculate levels. SquareX fails loudly rather than computing something subtly different.
How to fix it
Section titled “How to fix it”For dialect gaps: use a supported aggregate, or move the data. For composition limits: split the inner expression into its own measure and reference it, or restructure so the conflicting modifier targets a different column.