Dynamic measure swap in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Dynamic Measure Swap Using Parameter Selection

You have a Tableau parameter named Measure Selector with values: Sales, Profit, and Quantity. You want to create a calculated field that dynamically returns the selected measure's value.

Which of the following calculated field formulas correctly implements this dynamic measure swap?

A DNE )]ytitnauQ[(MUS ESLE )]tiforP[(MUS NEHT 'tiforP' = ]rotceleS erusaeM[ FIESLE )]selaS[(MUS NEHT 'selaS' = ]rotceleS erusaeM[ FI

B IF [Measure Selector] = 'Sales' THEN SUM([Sales]) ELSEIF [Measure Selector] = 'Profit' THEN SUM([Profit]) ELSE SUM([Quantity]) END

C IF [Measure Selector] = 'Sales' THEN [Sales] ELSEIF [Measure Selector] = 'Profit' THEN [Profit] ELSE [Quantity] END

D

CASE [Measure Selector]
WHEN 'Sales' THEN SUM([Sales])
WHEN 'Profit' THEN SUM([Profit])
WHEN 'Quantity' THEN SUM([Quantity])
END

💡 Hint

Remember that you need to aggregate the measures inside the calculated field to work correctly in Tableau.

Option D uses a CASE statement with aggregation functions SUM() for each measure, which is the correct way to dynamically swap measures based on a parameter in Tableau.

Option D uses valid IF-ELSEIF syntax but CASE is the preferred and more readable approach for multiple conditions in Tableau calculated fields.

Option D returns row-level values without aggregation, which will cause errors in aggregated views.

Option D uses SWITCH syntax which is not valid in Tableau calculated fields.

❓ visualization

intermediate

Best Visualization for Dynamic Measure Swap

You have implemented a dynamic measure swap in Tableau using a parameter to switch between Sales, Profit, and Quantity. You want to create a dashboard that clearly shows the selected measure over time.

Which visualization type is best suited to display this dynamic measure swap effectively?

A A scatter plot with Sales on x-axis and Profit on y-axis

B A pie chart showing the proportion of Sales, Profit, and Quantity for the latest date

C A line chart with the date on the x-axis and the dynamic measure on the y-axis

D A stacked bar chart showing Sales, Profit, and Quantity side by side

💡 Hint

Think about how to best show changes over time for a single selected measure.

A line chart is ideal to show trends over time for one measure, which fits the dynamic measure swap scenario.

Pie charts and stacked bars show multiple measures at once, which conflicts with the idea of swapping a single measure dynamically.

Scatter plots compare two measures, not suitable for a single dynamic measure over time.

❓ data_modeling

advanced

Data Model Considerations for Dynamic Measure Swap

You want to implement a dynamic measure swap in Tableau that allows users to select from multiple measures stored in different fact tables (e.g., Sales fact, Inventory fact).

What is the best data modeling approach to support this dynamic measure swap efficiently?

A Create a union of all fact tables with a measure type column and a measure value column, then use this combined table for dynamic swapping

B Create separate calculated fields for each fact table and use multiple parameters to switch between them

C Use blending to combine the fact tables at the visualization level and swap measures using parameters

D Duplicate the data source for each fact table and swap between data sources using parameters

💡 Hint

Think about how to unify measures from different tables into one structure for easy swapping.

Option A creates a single combined fact table with a measure type and value, which simplifies dynamic measure swapping.

Option A complicates the model with multiple parameters and calculated fields.

Option A (blending) is less efficient and harder to maintain.

Option A duplicates data sources, which is inefficient and not scalable.

🔧 Formula Fix

advanced

Debugging Incorrect Dynamic Measure Swap Output

You created a calculated field for dynamic measure swap using this formula:

IF [Measure Selector] = 'Sales' THEN [Sales]
ELSEIF [Measure Selector] = 'Profit' THEN [Profit]
ELSE [Quantity] END

When you use this field in a view aggregated by month, the values are incorrect or missing.

What is the main reason for this issue?

A The calculated field returns row-level values without aggregation, causing aggregation errors in the view

B The data source does not contain the Quantity field

C The ELSEIF syntax is invalid in Tableau calculated fields

D The parameter values do not match the strings in the calculated field

💡 Hint

Think about aggregation requirements when using calculated fields in aggregated views.

The calculated field returns raw row-level values without aggregation (SUM or AVG), so Tableau cannot aggregate them correctly in a monthly view.

Option A is unlikely if parameter values match.

Option A is incorrect because ELSEIF is valid syntax.

Option A would cause errors but not incorrect aggregation.

🧠 Conceptual

expert

Scenario: Performance Impact of Dynamic Measure Swap

You have a large dataset and implemented a dynamic measure swap using a parameter and a calculated field with multiple SUM aggregations. Users report slow dashboard performance.

Which approach will most effectively improve performance while keeping the dynamic measure swap functionality?

A Remove the dynamic measure swap and create separate dashboards for each measure

B Pre-aggregate the measures in the data source or extract and use those pre-aggregated fields in the dynamic measure swap calculation

C Replace the parameter with multiple filters to reduce data volume dynamically

D Use table calculations instead of aggregations in the calculated field

💡 Hint

Think about reducing the amount of data Tableau processes at runtime.

Pre-aggregating data reduces the volume Tableau processes, improving performance while keeping dynamic swapping.

Option B filters data but does not reduce aggregation complexity.

Option B loses the dynamic swapping benefit.

Option B often increases complexity and can hurt performance.