# Context filters, order of operations and filter scope

*Tableau Data Analyst Study Guide · Explore and Analyze Data · Last updated October 29, 2026 · https://www.certifyforce.com/study-guide/tableau-data-analyst/explore-and-analyze-data/context-filters-order-of-operations-and-filter-scope*

Trace Tableau's order of operations from extract filters to table calculation filters, use context filters to make Top N and FIXED results respect another filter, and choose the Apply to Worksheets scope or a cross-data-source relationship that makes one filter reach the right sheets.

- Certification: Salesforce Tableau Data Analyst
- Exam section: Explore and Analyze Data
- Study guide: https://www.certifyforce.com/study-guide/tableau-data-analyst

**Official exam objective:**

> Create and use filters: Apply filters to dimensions and measures; Configure filter settings including Top N, Bottom N, include, exclude, wildcard, and conditional; Add filters to context; Apply filters to multiple sheets and data sources.

## What the exam expects

- Place extract, data source, context, dimension, measure and table calculation filters, FIXED and INCLUDE/EXCLUDE expressions and blending in Tableau's order of operations, and predict which ones a filter affects.
- Add a filter to context so a Top N, conditional or FIXED calculation computes on the filtered rows.
- Choose an Apply to Worksheets scope: Only This Worksheet, Selected Worksheets (including All on dashboard), All Using This Data Source or All Using Related Data Sources.
- Filter across data sources with mapped relationships, and know why a blend's secondary source cannot drive the filter.
- The Filter dialog tabs (General include/exclude, Wildcard, Condition, Top/Bottom N) and measure filters are taught in Dimension, measure and Top N filter settings; adding a first filter in the Desktop Foundations unit Dimension filters, filter cards and date filters.

Key terms:
- **Order of operations:** the query pipeline that fixes when each filter and calculation runs.
- **Context filter:** an independent filter that runs before other worksheet filters, which become dependent filters.
- **Source field / target field:** in a cross-data-source filter, the field you filter with and the related field that is actually filtered on another sheet.
- **Primary data source:** in a blend, the first source used in the view, which defines it.

## Key facts

| Fact | Detail | Source |
|---|---|---|
| Default filter behaviour | All filters computed independently, each against all rows | [Use Context Filters](https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm) |
| Creating a context filter | Add to Context on an existing categorical filter | [Use Context Filters](https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm) |
| Context filters on the shelf | At the top, gray, cannot be rearranged | [Use Context Filters](https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm) |
| FIXED vs dimension filters | FIXED is computed before dimension filters, after context filters | [Tableau's Order of Operations](https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm) |
| After dimension filters | INCLUDE/EXCLUDE LOD and data blending, then measure filters | [Tableau's Order of Operations](https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm) |
| Last filter step | Table calculation filters | [Tableau's Order of Operations](https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm) |
| New filter scope | Current worksheet only, by default | [Apply Filters to Multiple Worksheets](https://help.tableau.com/current/pro/desktop/en-us/filtering_global.htm) |
| Back to Only This Worksheet | Copies stay on other sheets, disconnected and local | [Apply Filters to Multiple Worksheets](https://help.tableau.com/current/pro/desktop/en-us/filtering_global.htm) |
| All on dashboard | Button in Selected Worksheets from a dashboard filter card | [Apply Filters to Multiple Worksheets](https://help.tableau.com/current/pro/desktop/en-us/filtering_global.htm) |
| Secondary data source | Cannot be filtered across in Tableau Desktop | [Filter Data Across Multiple Data Sources](https://help.tableau.com/current/pro/desktop/en-us/filter_across_datasources.htm) |
| Unmatched target values | Excluded from target sheets and filter cards | [Filter Data Across Multiple Data Sources](https://help.tableau.com/current/pro/desktop/en-us/filter_across_datasources.htm) |
| Blend primary source | First source used in the view; like a left join | [Blend Your Data](https://help.tableau.com/current/pro/desktop/en-us/multiple_connections.htm) |

## Check yourself

- How do context filters look on the Filters shelf?
- When is the latest date preset determined in the pipeline?
- What does Remove from Context do to a filter?
- Why does a blend behave like a left join?

## Sources

- [Tableau's Order of Operations](https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm)
- [Use Context Filters](https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm)
- [Apply Filters to Multiple Worksheets](https://help.tableau.com/current/pro/desktop/en-us/filtering_global.htm)
- [Filter Data Across Multiple Data Sources](https://help.tableau.com/current/pro/desktop/en-us/filter_across_datasources.htm)
- [Blend Your Data](https://help.tableau.com/current/pro/desktop/en-us/multiple_connections.htm)
- [Filter Data from Your Views](https://help.tableau.com/current/pro/desktop/en-us/filtering.htm)

## About the full unit

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