# Order of operations effects on calculation results

*Tableau Consultant Study Guide · Design and Troubleshoot Calculations and Workbooks · Last updated November 3, 2026 · https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/order-of-operations-effects-on-calculation-results*

Predict what a calculation returns from where it sits in Tableau's query pipeline: FIXED before dimension filters, INCLUDE and EXCLUDE after them, measure filters at the view's level of detail, totals and clusters after measure filters, and table calculation filters and reference lines at the very end.

- Certification: Salesforce Tableau Consultant
- Exam section: Design and Troubleshoot Calculations and Workbooks
- Study guide: https://www.certifyforce.com/study-guide/tableau-consultant

**Official exam objective:**

> Identify the effect of the Tableau order of operations on calculations.

## What the exam expects

- Place each filter type and calculation in Tableau's order of operations and predict which filters a calculation sees.
- Predict how a dimension filter changes FIXED versus INCLUDE and EXCLUDE results, including ratios that use an LOD denominator.
- Predict what measure filters do to totals, clusters and INCLUDE averages, and when a FIXED-based filter is needed instead.
- Use a table calculation filter to hide rows while percentages, ranks and totals keep their full denominator, and know that reference lines follow it.
- Choose filter card options such as All Values in Context when a context filter is present.

Key terms:
- **Order of operations (query pipeline):** the fixed order in which Tableau performs filters and calculations.
- **Context filter:** a categorical filter computed first, so other filters process only the data that passes it.
- **Dimension filter:** a filter on rows, comparable to a SQL WHERE clause.
- **Measure filter:** a filter on an aggregated value, comparable to a SQL HAVING clause.
- **Table calculation filter:** a calculated field containing a table calculation placed on Filters; it hides marks after calculations run.

## Key facts

| Fact | Detail | Source |
|---|---|---|
| FIXED and filters | Ignores all filters except context, data source and extract filters | [Create LOD Expressions](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm) |
| INCLUDE and EXCLUDE | Considered after dimension filters | [How LOD Expressions Work](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_overview.htm) |
| Measure filter analogy | SQL HAVING clause; dimension filter is WHERE | [How LOD Expressions Work](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_overview.htm) |
| Totals and clusters | Computed after measure filters, with forecasts and table calcs | [Tableau's Order of Operations](https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm) |
| Top N filter | Treated as a dimension filter in the page's Example 1, so it runs simultaneously with general dimension filters and before table calcs | [Tableau's Order of Operations](https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm) |
| Table calculation filters | Applied last; do not filter out underlying data | [Filter Data from Your Views](https://help.tableau.com/current/pro/desktop/en-us/filtering.htm) |
| Trend and reference lines | After table calculation filters | [Tableau's Order of Operations](https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm) |
| Which filters can be context | Categorical filters only | [Use Context Filters](https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm) |
| All Values in Context | Tableau Desktop only; lists values passing the context filter | [Filter Data from Your Views](https://help.tableau.com/current/pro/desktop/en-us/filtering.htm) |

## Check yourself

- Why can't a measure filter be moved earlier with Add to Context?
- When is a worksheet's context recomputed?
- Which SQL clause does the LOD overview compare a dimension filter to?
- Where do context filters appear on the Filters shelf?

## Sources

- [Tableau's Order of Operations](https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm)
- [How Level of Detail Expressions Work in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_overview.htm)
- [Create Level of Detail Expressions in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm)
- [FIXED Level of Detail Expressions](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_fixed.htm)
- [Filter Data from Your Views](https://help.tableau.com/current/pro/desktop/en-us/filtering.htm)
- [Use Context Filters](https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm)

## About the full unit

The "Core concepts", "Exam traps" and "Worked scenario" sections of this unit, its 8 linked practice questions, and unlimited timed mock exams are included with the Tableau Consultant pack (USD $19): https://www.certifyforce.com/practice-exams