Context filters in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

How do context filters affect other filters in Tableau?

Imagine you have a sales dashboard with multiple filters. You add a context filter on Region. What happens to other filters applied after the context filter?

A Context filters are ignored if other filters are applied.

B Other filters ignore the context filter and apply to the entire dataset.

C Other filters are applied only to the data subset defined by the context filter.

D All filters are applied simultaneously without any order.

💡 Hint

Think about how Tableau processes filters step-by-step.

Context filters create a temporary table that other filters use as their data source. This means other filters only see data after the context filter is applied.

❓ dax_lod_result

intermediate

What is the effect of a context filter on a LOD expression in Tableau?

Given a context filter on 'Category' set to 'Furniture', what will the LOD expression { FIXED [Sub-Category] : SUM([Sales]) } return?

A Sum of sales for each Sub-Category across all categories ignoring the filter.

B Sum of sales for all categories combined, ignoring Sub-Category.

C Sum of sales for the Furniture category ignoring Sub-Category.

D Sum of sales for each Sub-Category within the Furniture category only.

💡 Hint

Remember that context filters affect the data before LOD calculations.

The context filter limits data to Furniture category first. Then the FIXED LOD calculates sales per Sub-Category within that filtered data.

❓ visualization

advanced

Identify the correct visualization behavior with context filters

You have a dashboard with a context filter on 'Year' set to 2023 and a regular filter on 'Region'. Which visualization behavior is correct?

A The visualization updates to show data only for 2023 and the selected Region.

B The visualization ignores the Year filter and shows all years for the selected Region.

C The visualization shows all Regions but only for 2023.

D The visualization shows all data ignoring both filters.

💡 Hint

Think about how context filters set the data scope first.

The context filter on Year limits data to 2023 first. Then the Region filter applies on that subset, so the visualization shows data for 2023 and selected Region.

🔧 Formula Fix

advanced

Why does the dashboard performance improve after adding a context filter?

You notice your Tableau dashboard runs faster after adding a context filter on 'Country'. Why is this happening?

A Because the context filter creates a temporary table that reduces data for other filters to process.

B Because context filters automatically aggregate data at a higher level.

C Because context filters cache the entire dataset in memory.

D Because context filters disable all other filters, reducing workload.

💡 Hint

Think about how Tableau processes data internally with context filters.

Context filters create a temporary table with filtered data. Other filters work on this smaller table, reducing processing time and improving performance.

🎯 Scenario

expert

Choosing context filters to solve a complex filtering scenario

You have a dataset with millions of rows. You want to filter sales data to only 'Electronics' category and then apply multiple other filters on sub-categories and regions. What is the best approach to optimize filtering and ensure correct results?

A Set all filters including sub-category and region as context filters.

B Set 'Category = Electronics' as a context filter, then apply other filters normally.

C Apply only the region filter as a context filter and others as regular filters.

D Apply all filters as regular filters without context filters.

💡 Hint

Consider how context filters reduce data before other filters apply.

Setting the broadest filter (Category = Electronics) as a context filter reduces data size early. Other filters then work on this smaller dataset, improving performance and accuracy.