+--------------------------------------------------------------------------+ | LOD TYPES | +---------------------------------+----------------------------------------+ | FIXED | Ignores dimensions in the view. | | | Locks to specified dimensions. | +---------------------------------+----------------------------------------+ | INCLUDE | Computes at the view level plus | | | specified dimensions. | +---------------------------------+----------------------------------------+ | EXCLUDE | Computes at the view level minus | | | specified dimensions. | +---------------------------------+----------------------------------------+ How FIXED Interacts with Tableau Filters
FIXED [Year] : MAX( FIXED [Region], [Year] : SUM([Profit]) ) Use code with caution. Common Mistakes to Avoid Misunderstanding Filter Behavior Standard filters will not change your FIXED totals. Right-click the filter and select Add to Context . Forgetting Aggregation Outside the LOD fixed calculation tableau
Fixed Calculation Expression Tagline: "Aggregate at the source, visualize at will." Description: The Fixed Calculation feature allows users to compute values at a specified level of granularity, independent of the dimensions present in the current view. Unlike standard aggregations (like SUM or AVG) that change based on the chart's filters or grouping, a Fixed Calculation locks the aggregation to specific dimensions defined by the user. Right-click the filter and select Add to Context
If you put Year = 2024 on the Filters shelf (as a Dimension filter), your FIXED calculation will ignore it . fixed calculation tableau
Convert your Dimension Filter to a Context Filter .