| Expression | Respects view dimensions? | Respects view filters? | |------------|---------------------------|------------------------| | | No (uses specified dimensions only) | No (unless context filter) | | INCLUDE | Yes (adds specified dimensions) | Yes | | EXCLUDE | Yes (removes specified dimensions) | Yes |
You must right-click your "Year" filter and select "Add to Context" . Context filters compute before FIXED LODs. Now your FIXED calculation will respect the Year filter. fixed in tableau
Create a second calculated field:
FIXED [Dimension1], [Dimension2] : AGGREGATE([Measure]) | Expression | Respects view dimensions
| Scenario | FIXED Expression | |----------|------------------| | Highest sales per customer, regardless of product or date | FIXED [Customer ID] : MAX([Sales]) | | Average regional target, no matter what city or store is in the view | FIXED [Region] : AVG([Target]) | | Percentage of total sales per category, not affected by year filters | FIXED [Category] : SUM([Sales]) / FIXED : SUM([Sales]) | Context filters compute before FIXED LODs