What is the difference between EXCLUDE LOD and a regular aggregate when a dimension filter is applied?

Tableau Hard

Tableau — Hard

What is the difference between EXCLUDE LOD and a regular aggregate when a dimension filter is applied?

Key points

  • EXCLUDE LOD is evaluated before dimension filters
  • Regular aggregates do not have the same evaluation timing as EXCLUDE LOD
  • Dimension filters may not affect EXCLUDE LOD results unless promoted to context filters
  • EXCLUDE LOD removes the specified dimension from the calculation

Ready to go further?

Start full exam Practice more questions

Related questions