Fixed
Fixed(dim…, expr) · Context
Evaluates expr grouped by exactly the listed dimensions, then joins the result back to the chart’s grain. Dimensions come first, the expression last (SQX007). Date columns take an inline grain: Fixed(Date.Date:month, …).
Filters just work: unlike Tableau’s FIXED, SquareX Fixed evaluates inside the active filter context — no context-filter promotion needed.
When the chart is coarser than the Fixed grain, the chart’s field-well aggregation re-aggregates the joined-back values — drop [CustomerRevenue] on a by-region chart with agg avg and you get average revenue per customer per region.
Example
Section titled “Example”CustomerRevenue := Fixed(Customer.Id, [Revenue])
CustomersPerMonth := Fixed(Date.Date:month, CountDistinct(Sales.CustomerId))Good to know
Section titled “Good to know”- Join-backs are LEFT JOINs: outer rows with no matching fixed group carry blank and outer re-aggregation skips them.
- In-language re-aggregation (
Avg([CustomerRevenue])) is not expressible yet — aggregation arguments are columns (SQX013); set the aggregation in the chart instead.