You know the struggle. You need to compare a sales rep’s individual deal size against the average deal size for their entire region . But the moment you try, Tableau either repeats the same number on every row or forces you to use cumbersome table calculations.
FIXED [Dimension1], [Dimension2] : AGG([Measure]) fixed tableau calculation
In this post, I’ll explain when and how to use FIXED, common pitfalls, and why it changes the game for cohort analysis and percent-of-total calculations. A FIXED calculation computes an aggregate value using only the dimensions you specify , ignoring all other dimensions in the current view. You know the struggle
FIXED is the most powerful—and often misunderstood—calculation in Tableau. Unlike its cousins (INCLUDE and EXCLUDE), FIXED operates of your worksheet’s filters and dimensions. It says, “Compute this value at this specific level, and I don’t care what else is on the view.” Unlike its cousins (INCLUDE and EXCLUDE), FIXED operates