Fixed Calculation Tableau -

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 have been using Tableau for more than a few weeks, you have probably hit the wall .

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

Create the FIXED calculation.

FIXED [Sub-Category] : MAX([Sales]) Wait, that gives me a number, not a flag. But when you filter the dashboard to "2024"

| LOD Type | Logic | Best for | | :--- | :--- | :--- | | | Calculate only by these dimensions. Ignore everything else in the view. | "What is the company max sales?" "First purchase date per user." | | INCLUDE | Calculate by view dimensions + these extra ones. | "What is the average sales per day, even if my view is by month?" | | EXCLUDE | Calculate by view dimensions, but remove these ones. | "What is the total US sales, ignoring state level detail?" |

You try a standard calculation: MIN(Order Date) . If you have been using Tableau for more

[Sales] = FIXED [Sub-Category] : MAX([Sales]) Drag this Flag to the Color shelf. Filter to True .