What happens to a FIXED LOD calculation when a dimension filter (not a context filter) is applied to the same dimension used in the FIXED expression?

Tableau Hard

Tableau — Hard

What happens to a FIXED LOD calculation when a dimension filter (not a context filter) is applied to the same dimension used in the FIXED expression?

Key points

  • FIXED LOD expressions are evaluated at a lower level than dimension filters
  • Dimension filters do not affect FIXED LOD calculations directly
  • The order of operations in Tableau determines the outcome
  • FIXED LOD returns values for all dimension members, including filtered ones

Ready to go further?

Related questions