Tableau-Desktop-Found Understanding Tableau Concepts Practice Question
An analyst creates a calculated field using a FIXED level of detail expression to calculate regional sales totals. When a standard dimension filter is applied to the worksheet, the fixed calculation does not change. Why does this occur in Tableau?
⚠ Common exam trap
Candidates often assume that all filters affect all calculations, failing to realize that FIXED LODs are specifically designed to ignore standard dimension filters because they process earlier in the pipeline.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Standard dimension filters execute after fixed level of detail expressions in the Tableau order of operations.
Fixed level of detail expressions compute values at the specified dimensions without regard for the view's layout or standard dimension filters because fixed expressions sit higher in Tableau's order of operations than dimension filters. This architectural design allows analysts to calculate cohort metrics and overall benchmarks that remain immune to standard user filtering within the worksheet view.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Fixed LOD expressions are permanently hardcoded into the data source schema during the initial connection phase.
Why it's wrong here
FIXED LOD expressions are computed at their declared dimension before dimension filters are applied, so the filter cannot alter the result; the data source schema is untouched. It is tempting because FIXED results appear static, but context filters and FIXED expressions would be the correct mechanism to make filters affect them.
- ✓
Standard dimension filters execute after fixed level of detail expressions in the Tableau order of operations.
Why this is correct
FIXED level of detail expressions are computed before dimension filters in Tableau's order of operations, using all underlying data regardless of the filter. The filter therefore cannot alter the fixed regional totals, which is why they remain unchanged.
- ✗
Fixed LOD calculations automatically convert all measures into discrete dimensions upon initial compilation.
Why it's wrong here
FIXED LOD expressions return aggregated measures at the declared level; they never convert measures to discrete dimensions. It is tempting because FIXED results can be used as dimensions in views, but the actual cause is that dimension filters are applied after FIXED calculations, unlike context filters.
- ✗
The analyst forgot to add the region field to the Marks card as a detail attribute before applying the filter.
Why it's wrong here
Marks card detail attributes affect visual grouping, not the order in which filters and FIXED calculations are evaluated. It is tempting because adding Region to Detail does change displayed granularity, but the filter still executes after the FIXED expression, so the regional total remains unchanged.
About these practice questions
Courseiva writes every Tableau-Desktop-Found question from scratch — 126 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Tableau (Salesforce) exam blueprint
This Tableau-Desktop-Found practice question is part of Courseiva's free Tableau (Salesforce) certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Tableau-Desktop-Found exam.