hard20 pts · first answer countstableaubi-tools

FIXED LOD ignores a filter

In Tableau, a calculation {FIXED [Customer] : SUM([Sales])} keeps showing all-year totals even after you add a Year filter showing only 2026. Why, and what is the usual fix?

A.FIXED only works with measure filters; convert Year to a measureB.FIXED expressions are computed before normal dimension filters; add the Year filter to contextC.LOD calculations are cached until the workbook is reopenedD.The calculation should use INCLUDE, which is always filtered first

Discussion 0

Join free to post in the discussion.

FIXED LOD ignores a filter

Discussion 0

Related questions