Measure filters in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Calculate total sales with measure filter applied

You have a sales dataset with a measure called Sales Amount. You want to calculate the total sales but only for transactions where the Sales Amount is greater than 1000. Which Tableau calculation will correctly apply this measure filter?

A SUM([Sales Amount]) WHERE [Sales Amount] > 1000

B SUM(IF [Sales Amount] > 1000 THEN [Sales Amount] ELSE 0 END)

C IF SUM([Sales Amount]) > 1000 THEN SUM([Sales Amount]) END

D SUM(IF [Sales Amount] > 1000 THEN [Sales Amount] END)

💡 Hint

Think about how Tableau handles conditional aggregation inside SUM().

Option D correctly sums only the sales amounts greater than 1000 by using an IF inside the aggregation. Option D uses ELSE 0 which is valid but less efficient. Option D is invalid syntax in Tableau. Option D incorrectly applies the condition after aggregation.

❓ visualization

intermediate

Best visualization to show filtered measure sales by category

You want to create a dashboard showing total sales by product category, but only including sales where the amount is above 500. Which visualization type best communicates this filtered measure data clearly?

A Scatter plot showing sales amount vs. category without filtering

B Stacked bar chart showing total sales by category with a filter on sales > 500

C Line chart showing sales trend over time without filtering

D Pie chart showing percentage of total sales by category including all sales

💡 Hint

Think about which chart type clearly compares categories with filtered totals.

A stacked bar chart with the filter applied clearly shows total sales by category only for sales above 500. Pie charts and scatter plots without filtering do not focus on the filtered measure. Line charts show trends over time, not category totals.

🧠 Conceptual

advanced

Understanding measure filters vs dimension filters

Which statement best explains the difference between measure filters and dimension filters in Tableau?

A Measure filters filter data after aggregation, dimension filters filter data before aggregation

B Measure filters filter data before aggregation, dimension filters filter data after aggregation

C Both measure and dimension filters filter data before aggregation

D Both measure and dimension filters filter data after aggregation

💡 Hint

Think about when the filtering happens in the data flow.

Dimension filters limit the rows before aggregation happens, so they filter raw data. Measure filters apply conditions on aggregated results, so they filter after aggregation.

🔧 Formula Fix

advanced

Identify the error in this measure filter calculation

Given the calculation below, what error will Tableau show?

IF SUM([Profit]) > 1000 THEN [Profit] END

Tableau

IF SUM([Profit]) > 1000 THEN [Profit] END

A Error: Syntax error due to missing ELSE clause

B No error, calculation runs correctly

C Error: Cannot mix aggregate and non-aggregate functions

D Error: SUM function cannot be used inside IF statement

💡 Hint

Check if all parts of the calculation use aggregation consistently.

The calculation mixes an aggregate function SUM([Profit]) with a non-aggregate field [Profit] in the THEN clause, which Tableau does not allow.

🎯 Scenario

expert

Create a measure filter to show average sales only for categories with total sales above 10,000

You want to create a calculated field that shows the average sales per transaction, but only for product categories where the total sales exceed 10,000. Which Tableau calculation achieves this?

A IF { FIXED [Category] : SUM([Sales]) } > 10000 THEN AVG([Sales]) END

B IF SUM([Sales]) > 10000 THEN AVG([Sales]) END

C IF AVG([Sales]) > 10000 THEN AVG([Sales]) END

D IF { INCLUDE [Category] : AVG([Sales]) } > 10000 THEN AVG([Sales]) END

💡 Hint

Use a Level of Detail (LOD) expression to calculate total sales per category first.

Option A uses a FIXED LOD to calculate total sales per category, then filters categories with total sales above 10,000 before calculating average sales. Option A filters on aggregated sales without fixing category, causing incorrect results. Option A filters on average sales, not total. Option A uses INCLUDE which is not appropriate here.