If you are in doubt, use FIXED . It gives you the most control because it does not try to guess what dimensions are in your view. The Silent Killer: Dimension Filters You must know one danger: Order of Operations .
But when you filter the dashboard to "2024" only, that MIN changes. The customer who first bought in 2020 suddenly shows a first purchase date of 2024. The calculation is .
If you just count Customer Name by Month of Order Date , you are counting transactions , not unique customers. Worse, if someone bought in Jan and Feb, they appear in both months.
Result: Tableau looks at all chairs, finds the single highest sales number, and highlights only that row. Do not try to memorize every LOD syntax. Instead, memorize this question:
[Sales] = FIXED [Sub-Category] : MAX([Sales]) Drag this Flag to the Color shelf. Filter to True .
Have you used FIXED to solve a tricky business problem? Share your example in the comments below.
FIXED [Sub-Category] : MAX([Sales]) Wait, that gives me a number, not a flag.