Fixed In: Tableau [best]

The primary advantage of using FIXED is that it operates independently of the "Viz LOD" (the dimensions in your chart). This makes it essential for several high-level analytical tasks: Intro to Tableau LODs (fixed) - The Data School

FIXED tells Tableau to ignore the view's level of detail. fixed in tableau

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. The primary advantage of using FIXED is that