PowerFix
Description
PowerFix pre-aggregates a measure by fixed dimensions, independent of dimensions added by the query.
Syntax
PowerFix(aggregate_expression[, dimension1[, dimension2...]][, filter1[, filter2...]][, RemoveFilter(...)])
Parameters
| Parameter | Required | Type | Description |
|---|---|---|---|
aggregate_expression |
Yes | Expression | Aggregation expression. It must contain an aggregate function. |
dimension |
No | Field | Fixed classification dimension. |
filter |
No | Expression | Filter applied before aggregation. |
RemoveFilter |
No | Expression | Removes filters from the current calculation context. |
Notes
Pre-aggregation functions must be used inside supported metric expressions and cannot be nested inside other pre-aggregation functions unless explicitly supported.
Example
The expression returns the calculated result according to the current query context.