Fixed Calculation Tableau May 2026

But what if you want the FIXED calculation to respect the year?

Create the Boolean Flag.

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 . fixed calculation tableau

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.

[Sales] = FIXED [Sub-Category] : MAX([Sales]) Drag this Flag to the Color shelf. Filter to True . But what if you want the FIXED calculation

You are experiencing the tension between and Aggregate Level calculations.

You drag Sales into the view, add Region , and everything looks perfect. But the moment you try to answer a complex question—like “What is the average sales per customer, regardless of my date filters?” or “Show me the highest selling product in each state” —your numbers suddenly look wrong. The customer who first bought in 2020 suddenly

If you have been using Tableau for more than a few weeks, you have probably hit the wall .