Tableau: Fixed Calculation

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.

If you put Year = 2024 on the Filters shelf (as a Dimension filter), your FIXED calculation will ignore it . fixed calculation tableau

In Tableau, when you use the FIXED keyword in a calculated field, you're essentially telling Tableau to compute the calculation once for the entire data set, without regard to the filters, rows, columns, or level of detail in your view. The result of a FIXED calculation does not change based on the level of detail in the view; it is computed once for the data source. If you just count Customer Name by Month

The mathematical operation performed (e.g., SUM , AVG , MAX ). FIXED vs. INCLUDE vs. EXCLUDE In Tableau, when you use the FIXED keyword

Mastering FIXED LOD Calculations in Tableau Tableau's Level of Detail (LOD) expressions allow you to compute values at the data source level and the visualization level. Among these, the calculation is the most powerful and frequently used.

FIXED [dimension1], [dimension2], ... : expression