Measure filters in Tableau - Cell-by-Cell Formula Trace

Sample Data

This data shows sales amounts for different fruit products.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	100
A3	Bananas
B3	50
A4	Cherries
B4	200
A5	Dates
B5	30

Formula Trace

IF SUM([Sales]) > 50 THEN 'Keep' ELSE 'Filter Out' END

Step 1: SUM([Sales]) for Apples

Step 2: 100 > 50

Step 3: IF TRUE THEN 'Keep' ELSE 'Filter Out' END

Step 4: SUM([Sales]) for Bananas

Step 5: 50 > 50

Step 6: IF FALSE THEN 'Keep' ELSE 'Filter Out' END

Step 7: SUM([Sales]) for Cherries

Step 8: 200 > 50

Step 9: IF TRUE THEN 'Keep' ELSE 'Filter Out' END

Step 10: SUM([Sales]) for Dates

Step 11: 30 > 50

Step 12: IF FALSE THEN 'Keep' ELSE 'Filter Out' END

Cell Reference Map

    A       B
1 Product  Sales
2 Apples   100
3 Bananas  50
4 Cherries 200
5 Dates    30

Arrows show SUM([Sales]) used for each product row.

The formula uses the Sales values from column B for each product in column A to decide if the product is kept or filtered out.

Result

    A       B       C
1 Product  Sales   Filter Result
2 Apples   100     Keep
3 Bananas  50      Filter Out
4 Cherries 200     Keep
5 Dates    30      Filter Out

The Filter Result column shows which products pass the measure filter (Sales > 50) and which do not.

Sheet Trace Quiz - 3 Questions

What is the filter result for Bananas with sales of 50?

A Filter Out

B Error

C Keep

D Keep if sales equal 50

Key Result

IF SUM([Measure]) > Threshold THEN 'Keep' ELSE 'Filter Out' END