Fixed Calculation Tableau =link= May 2026

Imagine you have a dataset with 10,000 rows. A FIXED calculation runs once, creates a temporary lookup table (e.g., 100 unique customers), and then pastes that result back onto every relevant row.

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

| 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?" | Imagine you have a dataset with 10,000 rows

Have you used FIXED to solve a tricky business problem? Share your example in the comments below. | LOD Type | Logic | Best for

But LODs require you to think .

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 .

This is wrong. You need a calculation that ignores the date filter. The FIXED calculation tells Tableau: "Compute this value using these specific dimensions, and ignore all other filters (except context filters and data source filters)." The Syntax FIXED [Customer Name] : MIN([Order Date]) Translation: "Lock onto each unique Customer. Look at all the Order Dates available for that customer (ignoring my current date filters). Give me the very first one." Real-World Example: Customer Retention Imagine you want to know how many new customers you acquired each month.