Explore and Analyze Data41% of the exam
Dimension, measure and Top N filter settings
Configure the dimension Filter dialog (General include/exclude, Wildcard, Condition, Top and Bottom N, and how the tabs combine), choose Range of Values, At Least, At Most or Special for measure filters, and set filter card modes, Only Relevant Values, Apply and Include/Exclude options.
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.
~8 min read · 9 practice questions ·
What the exam expects
- Pick the Filter dialog tab (General include/exclude, Wildcard, Condition, Top or Bottom N) and predict how one filter's tabs combine.
- Configure a measure filter: aggregation, then Range of Values, At Least, At Most or Special.
- Keep or exclude marks, and know when those commands disappear.
- Set filter card modes, Only Relevant Values and Customize options.
- Context filters and multi-sheet or multi-source filters are in Context filters, order of operations and filter scope; first filter cards in the Desktop Foundations unit Dimension filters, filter cards and date filters.
Key terms:
- Dimension filter: includes or excludes members of a discrete field.
- Measure filter: keeps a range of aggregated values.
- Top N filter: a limit relative to the other members of the field.
- Only Relevant Values: a card lists only values passing the other filters.
Key facts
Dimension Filter dialog tabs
- Detail
- General, Wildcard, Condition, Top
Tabs within one filter
- Detail
- Additive from General rightward; Summary shows all definitions
Measure filter first step
- Detail
- Choose the aggregation
Range of Values
- Detail
- Specified minimum and maximum are included
Special
- Detail
- Null, Non-null or All Values
Keep Only and Exclude missing
- Detail
- A Wildcard Match filter already exists on that field
Show Apply Button
- Detail
- Multiple values lists and dropdowns only
Filter order
- Detail
- Measure filters run after dimension filters
- When does a card set to All Values in Context list a value?
- Why doesn't changing a filter card's mode change which values it lists?
- Which filter card mode selects every value beginning with the typed letters, such as "tab*"?
- What can the Condition tab use besides its built-in controls?
The questions are free to read. Answers with their sources and self-grading are included with the pack.
Keep reading with the Tableau Data Analyst pack
- Core concepts
- Exam traps
- Worked scenario
The pack includes:
- All 30 lessons of the Tableau Data Analyst guide, with reading progress
- Interactive decision walks and step-by-step sequence steppers
- Practice exams purchase adds inline bank questions and topic practice (9 questions for this lesson)
- An official source cited for every claim
- An AI tutor that answers from the guide
- Choose guide-only, practice-only, or save $4 with both