How to Filter Measure Values in Tableau

Trying to filter an aggregated value in Tableau, like SUM(Sales) or AVG(Profit), can feel a bit confusing at first. You drag it to the Filters shelf expecting it to work like a dimension, but the options look completely different. This article will walk you through exactly how to filter measure values in Tableau, giving you the control to focus your analysis on the data that matters most.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First, A Quick Refresher: Dimensions vs. Measures

Before diving into the "how," let's quickly clarify the "what." In Tableau, your data fields are divided into two main categories:

• Dimensions: These are qualitative, categorical fields that you use to slice and dice your data. Think of them as the "who, what, and where." Examples include Region, Product Category, and Customer Name. When you drag a dimension to a view, it creates labels and new headers.
• Measures: These are quantitative, numerical fields that you can perform mathematical operations on. Think of them as the "how much" or "how many." Examples include Sales, Profit, and Quantity. When you drag a measure to a view, Tableau automatically aggregates it (e.g., SUM, AVG, COUNT).

The core challenge is that filtering dimensions sets the boundaries before aggregation, while filtering measures often requires you to set boundaries after the aggregation has happened. Let’s look at the best ways to do this.

Method 1: The Direct Approach (Using a Continuous Measure Filter)

The most straightforward way to filter a measure is to apply a filter directly to its aggregated value. This is ideal when you want to filter based on a continuous range, like showing only an author’s posts that have between 1,000 and 5,000 lifetime views or finding sales regions that generated over $500,000 in revenue.

This filter operates on the final, aggregated number you see in your visualization, not the individual records that make up that number.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Example: Filtering for High-Value Sales

Let's use the sample Superstore dataset. Imagine we have a bar chart showing the total sales for each Product Sub-Category and we only want to see the sub-categories that have generated over $150,000 in sales.

1. Build the Basic View: Place Product Sub-Category on the Rows shelf and SUM(Sales) on the Columns shelf. You'll see a standard bar chart of all sub-categories.
2. Drag the Measure to Filters: Drag the Sales field from the Measures pane and drop it directly onto the Filters card.
3. Choose an Aggregation: A dialog box will pop up asking how you want to filter the field. Since our view is using SUM(Sales), we should select Sum here to be consistent. Click Next.
4. Define the Filter Range: Now you see the Filter dialog box. You have a few options:
5. Set Your Condition: Select At least and type 150000 into the box. Then click OK.

Your chart immediately updates, removing any sub-category with total sales under $150,000. To let an end-user control this, you can right-click the SUM(Sales) pill on the Filters shelf and select Show Filter. This adds an interactive slider or text box to your worksheet or dashboard.

Method 2: Creating a Powerful Boolean Filter with a Calculated Field

For more specific or complex conditions, the standard measure filter might not be enough. This is where calculated fields become your best friend. The idea is to create a calculation that results in a simple "True" or "False" answer, then use that to filter your view.

Imagine you're managing a sales team and you only want to focus on sales reps who met a specific quota or have an average deal size above a certain amount. A boolean filter handles this perfectly.

Step-by-Step Example: Filtering for Profitable Sub-Categories

Sticking with our Superstore data, let's create a bar chart showing sales by product sub-category, but this time we only want to see the sub-categories that are actually profitable.

1. Create Your Initial View: Drag Product Sub-Category to the Rows shelf and SUM(Sales) to the Columns shelf. To add context, also drag SUM(Profit) to the Color card on the Marks pane. You'll see profitable bars in a different color from unprofitable ones.
2. Create a Calculated Field: Go to the top menu and select Analysis > Create Calculated Field.
3. Write the Logical Formula: The calculation window will open.
4. Apply the Calculated Field as a Filter: Click "OK" to save the calculation. Find your new Is Profitable? field in the Measures pane (it will have a "T|F" icon). Drag it onto the Filters shelf.
5. Select "True": A small dialog box will appear. Check the box for True and click "OK".

Instantly, all the unprofitable sub-categories disappear from your chart. You've successfully filtered an aggregated view based on a custom logical condition.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why This Method is So Useful

• It allows for more complex logic: SUM([Sales]) > 10000 AND AVG([Discount]) < 0.10
• The name of your calculated field (e.g., "High Performance Reps") makes the filter's purpose immediately clear to anyone viewing your workbook.

Method 3: Taking Control with Parameters for Dynamic Filtering

Hard-coding values like $150,000 is fine, but what if you want to let your audience decide the threshold? That’s where parameters come in. A parameter is a user-defined input that can be integrated into your calculations and filters, making your dashboards truly interactive.

Step-by-Step Example: A User-Defined Sales Threshold

Let's empower users to set their own sales threshold for which sub-categories they want to see.

1. Create a Parameter:
2. Create a Calculated Field that Uses the Parameter:
3. Apply the Filter:

Now, your view is filtered to show sub-categories that meet the $100,000 sales target. More importantly, your user can now type any number into the "Sales Target" box, and the chart will update in real-time. This is one of the most effective ways to create user-driven analytics dashboards in Tableau.

Method 4: Filtering Based on Rank or Percentile with Table Calculations

Sometimes you need to filter based on a relative position, not an absolute value. For instance, you might want to see the "top 10 performing products" or "bottom 5 sales regions." Since these calculations depend on the other data in the view (a product's rank depends on the sales of all other products), you need a special kind of filter: a table calculation filter.

This is an advanced technique because it operates very late in Tableau’s order of operations, an important distinction we won’t dive into here - just know it works on the table of data you see, not the data source.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Example: Finding the Top 5 Sub-Categories by Profit

1. Build Your Table: Put Product Sub-Category on the Rows shelf and SUM(Profit) on the Text card. Sort the view descending to bring the highest-profit items to the top.
2. Create a Rank Calculation: Create a new calculated field named Profit Rank. The formula is simply:
3. Convert to Discrete and Apply to Rows: Find Profit Rank in the Measures pane, right-click it, and select Convert to Discrete. Then drag it to the Rows shelf, placing it right before the Product Sub-Category pill. It should now show a rank number next to each sub-category.
4. Apply the Rank as a Filter: Now, drag the Profit Rank pill from the Rows shelf (or from your Measures pane again, as a continuous measure this time) and drop it on the Filters shelf.
5. Click OK: Your view is now filtered to show only the Top 5 most profitable sub-categories. You can then change your visualization from text back into a bar chart, and the filter will remain applied.

This same approach can be used with other table calculations like INDEX(), PERCENTILE(), or MOVINGAVERAGE() to build highly specific, conditional views of your data.

Final Thoughts

Filtering measures is a fundamental skill in Tableau that moves you from simply displaying data to asking targeted questions. Whether you're using a direct continuous filter for a simple range, a boolean calculation for a specific condition, a parameter for interactivity, or a table calculation for ranking, each method gives you a different way to narrow your focus and find meaningful insights.

Mastering these techniques takes a little practice, but it's often the small adjustments to your filters that unlock the biggest discoveries. If you find yourself spending a lot of time wrestling with Tableau's interface and just want to get to the answer, platforms are now emerging that simplify this whole process. We built Graphed to let you ask your data questions in plain English - like "show me my most profitable product categories" or "which campaigns had revenue over $10,000 last month?" - and get a real-time dashboard built for you instantly, without creating a single calculated field.