Course: Tableau Training
Topic: Understanding, Creating, Comparing, and Using Dimension and Measure Filters
Learning Objective: Learn how dimension filters and measure filters work in Tableau, how to configure them, how they affect aggregated data, and how to use them to build interactive dashboards and reports.
Filters in Tableau are used to limit the data displayed in a worksheet, chart, table, or dashboard. They help analysts focus on relevant information instead of viewing every record in a dataset. Filters can be applied to categorical fields, numerical fields, dates, and other data attributes.
For example, a sales analyst may want to view only sales from the West region, products belonging to the Furniture category, or records where total sales exceed ₹50,000. Tableau allows these requirements to be handled through different types of filters.
Two important filter types are:
Dimension filters generally determine which dimension members or underlying records are included. Measure filters generally determine which aggregated values remain visible at the level of detail of the visualization.
A dimension is a field that helps describe, classify, group, or identify data. Dimensions are commonly used to organize information into categories and compare results across groups.
| Dimension | Example Values | Purpose |
|---|---|---|
| Region | East, West, North, South | Groups data by geographical region. |
| Category | Furniture, Office Supplies, Technology | Groups products by category. |
| Customer Name | Amit, Priya, Rahul | Identifies individual customers. |
| Product Name | Chair, Laptop, Printer | Identifies products. |
| Order Date | 2026-01-10, 2026-02-15 | Organizes orders by date or date period. |
| Segment | Consumer, Corporate, Home Office | Groups customers into business segments. |
A measure is a field that represents a quantity that can usually be calculated, summarized, or aggregated. Measures are commonly used to calculate totals, averages, counts, minimums, and maximums.
| Measure | Example Values | Purpose |
|---|---|---|
| Sales | ₹10,000, ₹25,000 | Measures revenue or sales value. |
| Profit | ₹2,000, ₹5,000 | Measures profitability. |
| Quantity | 2, 5, 10 | Measures the number of units. |
| Discount | 0.05, 0.10, 0.20 | Represents discount values or rates, depending on the dataset. |
| Order ID Count | 100, 250, 500 | Can represent the number of orders when calculated appropriately. |
| Aggregation | Meaning | Example |
|---|---|---|
| SUM() | Adds values together. | SUM([Sales]) |
| AVG() | Calculates the average. | AVG([Sales]) |
| MIN() | Returns the minimum value. | MIN([Profit]) |
| MAX() | Returns the maximum value. | MAX([Sales]) |
| COUNT() | Counts non-null field values. | COUNT([Order ID]) |
| COUNTD() | Counts distinct values. | COUNTD([Customer ID]) |
Important: A measure filter commonly works on an aggregated value. For example, filtering SUM(Sales) to values greater than ₹50,000 means Tableau retains groups whose aggregated sales satisfy that condition. The result depends on the dimensions defining the view.
A dimension filter is a filter created using a dimension field. It lets you include or exclude particular categories, names, regions, dates, or other dimension members.
Example: A company has sales records for four regions: East, West, North, and South. If the analyst wants to see only West region sales, the Region field can be added to the Filters shelf and configured to include West.
| Option | Description | Example |
|---|---|---|
| General | Selects specific members to include or exclude. | Include only West and East. |
| Wildcard | Matches members using a text pattern. | Product names beginning with "Sam". |
| Condition | Filters members based on a field condition or formula. | Customers whose sales meet a specified condition. |
| Top | Retains the Top or Bottom N members based on a selected measure. | Top 10 products by SUM(Sales). |
Note: The available options depend on the field and data source. Dimension filter settings across the dialog tabs are cumulative, so multiple conditions can restrict the final results together.
Suppose the dataset contains the following sales values:
| Region | Sales |
|---|---|
| East | ₹40,000 |
| West | ₹75,000 |
| North | ₹35,000 |
| South | ₹50,000 |
If you apply a dimension filter on Region and select only West, the resulting view contains West and its sales value of ₹75,000. The other regions are excluded from the filtered view.
A measure filter is created using a quantitative field, such as Sales, Profit, or Quantity. It allows you to retain data based on numerical conditions, commonly using an aggregated measure.
Example: A manager wants to view only regions where total sales exceed ₹50,000. Drag Sales to the Filters shelf, select the appropriate aggregation, and configure the filter condition.
| Option | Description | Example |
|---|---|---|
| Range of Values | Includes values between a minimum and maximum, including the boundaries. | Sales from ₹20,000 to ₹80,000. |
| At Least | Includes values greater than or equal to a specified minimum. | SUM(Sales) ≥ ₹50,000. |
| At Most | Includes values less than or equal to a specified maximum. | SUM(Profit) ≤ ₹10,000. |
| Special | Controls whether to include null values, non-null values, or all values where supported. | Show only non-null measure values. |
Consider the following summarized sales data:
| Region | Total Sales |
|---|---|
| East | ₹40,000 |
| West | ₹75,000 |
| North | ₹35,000 |
| South | ₹60,000 |
Apply a measure filter to SUM(Sales) with the condition At Least ₹50,000. The resulting view retains West with ₹75,000 and South with ₹60,000. East and North do not satisfy the condition and are removed from the view.
| Basis | Dimension Filter | Measure Filter |
|---|---|---|
| Field type | Uses a dimension. | Uses a measure. |
| Main purpose | Selects categories or dimension members. | Selects values satisfying numerical or aggregation criteria. |
| Typical fields | Region, Category, Customer, Product. | Sales, Profit, Quantity. |
| Common conditions | Member selection, text patterns, conditions, Top/Bottom N. | Value ranges, minimums, maximums, and null handling. |
| Example | Show only the West region. | Show groups where SUM(Sales) is above ₹50,000. |
| Effect | Generally filters dimension members and their underlying records. | Generally filters aggregated results at the level of detail in the view. |
| Order of operations | Normally executes before measure filters. | Normally executes after dimension filters. |
| SQL analogy | Often similar to WHERE filtering. | Often similar to HAVING filtering on aggregated results. |
| Common use | Choose which business area or category to analyze. | Choose which groups meet a performance threshold. |
Imagine a sales dataset with individual orders. You place Region on Rows and SUM(Sales) on Columns to create a bar chart.
You filter Region to include only West. Tableau excludes records belonging to other regions from the filtered analysis. The remaining sales are then summarized for the West region.
You apply a filter on SUM(Sales) to keep values greater than ₹50,000. Tableau evaluates the aggregated sales at the view's level of detail and retains only groups whose total sales satisfy the condition.
You filter Region to West and East, then apply SUM(Sales) greater than ₹50,000. Tableau first applies the dimension filter, then evaluates the measure filter on the groups that remain. Only groups satisfying both conditions appear.
Key learning: A dimension filter determines which members or underlying records participate in the analysis. A measure filter determines which aggregated results remain visible. The exact result depends on the fields and level of detail in the view.
In practical Tableau dashboards, both types are often used together. Dimension filters narrow the scope of analysis, while measure filters focus the results on relevant performance levels.
Business requirement: Show sales for selected product categories and retain only regions with total sales of at least ₹100,000.
The resulting view displays only the selected categories' sales and retains region-level results that satisfy the measure threshold.
Tableau evaluates different filter types in a defined order. Understanding this order helps explain why a filtered view may not produce the result you initially expect.
A simplified order for common filter types is:
This is a simplified list of common filter stages, not a complete description of every operation in Tableau. Level of detail expressions and other features have specific evaluation rules.
Suppose a worksheet contains Region, Category, and SUM(Sales). A dimension filter restricts the records or members used in the analysis. A measure filter then evaluates the aggregated values that result from the remaining data and the level of detail in the view.
Tableau's order of operations also matters when using FIXED, INCLUDE, or EXCLUDE level of detail expressions. FIXED expressions are evaluated before ordinary dimension filters unless the relevant filters are made context filters. INCLUDE and EXCLUDE expressions are evaluated later than dimension filters in the documented order.
A context filter creates a primary filtering context for other filters on a worksheet. It can be useful when you need subsequent dimension filters to work against a restricted subset of data, including certain Top N analyses.
To create one, right-click the relevant field on the Filters shelf and select Add to Context. Tableau displays the context filter in a distinct style.
Important: Do not add every filter to context automatically. Use context filters when the required filtering logic or performance characteristics justify them.
The General tab allows you to choose specific members to include or exclude. For example, select Technology and Furniture from Category to limit the analysis to those categories.
A wildcard filter matches members according to a text pattern. For example, a pattern such as Lap* can match product names beginning with "Lap", depending on the available values and pattern rules.
A condition filter keeps members that satisfy a specified condition. Conditions can be based on a field or a formula, depending on the available settings. For example, use a sales-based condition to identify customers whose sales meet a business requirement.
A Top filter keeps the highest-ranking or lowest-ranking members according to a selected measure. For example, display the Top 10 products by SUM(Sales). A Top filter on a dimension is different from simply filtering SUM(Sales) above a fixed threshold.
When a measure is dragged to the Filters shelf, Tableau typically asks how the measure should be aggregated or filtered. Selecting the correct aggregation is essential because different aggregations can produce different results.
| Filter Expression | Meaning |
|---|---|
| SUM([Sales]) | Evaluates total sales at the relevant level of detail. |
| AVG([Sales]) | Evaluates average sales at the relevant level of detail. |
| MIN([Sales]) | Evaluates the minimum sales value at the relevant level of detail. |
| MAX([Sales]) | Evaluates the maximum sales value at the relevant level of detail. |
| COUNT([Order ID]) | Counts non-null order ID values at the relevant level of detail. |
| COUNTD([Customer ID]) | Counts distinct customers at the relevant level of detail. |
Example: A region may have 100 individual sales records. Filtering individual sales values is not the same as filtering the region's total sales. When the requirement is to show regions with total sales above ₹100,000, use an appropriate aggregated measure filter, such as SUM(Sales).
Objective: Create a worksheet that shows selected categories and only the region-level sales results above a specified threshold.
The worksheet shows sales for the selected categories and retains region-level aggregated results that satisfy the configured measure filter. Exact values depend on the dataset and filter settings.
| Business Requirement | Filter Type | Example Configuration |
|---|---|---|
| Analyze sales from the West region. | Dimension | Region = West. |
| Show only Technology products. | Dimension | Category = Technology. |
| Display regions with sales above ₹100,000. | Measure | SUM(Sales) ≥ ₹100,000. |
| Display groups with profit below ₹10,000. | Measure | SUM(Profit) ≤ ₹10,000. |
| Show the Top 10 products by sales. | Dimension filter with Top configuration | Product Name → Top 10 by SUM(Sales). |
| Analyze selected customers with high sales. | Both | Select customers, then filter their aggregated sales. |
| Analyze orders in a particular year and retain high-sales groups. | Both | Filter Order Date, then filter aggregated Sales. |
Problem: You want to show only a specific region but try to use a measure filter.
Solution: Use a dimension filter on Region. Use measure filters for numerical conditions on measures or their aggregations.
Problem: The result changes unexpectedly when switching from SUM(Sales) to AVG(Sales).
Solution: Confirm the business question. Use SUM for total sales and AVG for average sales when those are the intended metrics.
Problem: A measure filter returns different results after adding or removing a dimension from the view.
Solution: Check the level of detail. A measure filter evaluates the relevant aggregated values, and changing the dimensions in the visualization can change those aggregates.
Problem: You need the 10 highest-selling products but filter sales to values greater than a fixed amount.
Solution: Use a Top filter on the product dimension when the requirement is to retain the top 10 products. Use a measure threshold when the requirement is to retain every group above a specified value.
Problem: A FIXED LOD calculation still reflects data outside the selected dimension members.
Solution: Review Tableau's order of operations. FIXED expressions are evaluated before ordinary dimension filters. A context filter or a different calculation design may be appropriate, depending on the requirement.
Problem: A dashboard becomes slow or difficult to use.
Solution: Keep only relevant filters, limit unnecessarily large member lists, and test performance. For large data sources, measure filtering can sometimes be expensive; consider whether a set or another data-modeling approach is more appropriate.
Answer: A dimension filter uses a dimension field to include or exclude specific members or categories, such as regions, customers, product categories, or dates.
Answer: A measure filter uses a quantitative field and commonly filters its aggregated values, such as SUM(Sales), AVG(Profit), or COUNT(Order ID), according to specified criteria.
Answer: Dimension filters select dimension members or underlying records, while measure filters generally select aggregated results at the level of detail defined by the view.
Answer: Drag a dimension to the Filters shelf, choose the required members or configure a suitable condition, and apply the filter.
Answer: Drag a measure to the Filters shelf, choose the required aggregation, select a filter type such as Range of Values or At Least, and configure the criteria.
Answer: Yes. For example, select the West region with a dimension filter and then retain only groups whose SUM(Sales) exceeds ₹50,000 with a measure filter.
Answer: A Top N filter retains a specified number of highest- or lowest-ranked dimension members according to a measure. A threshold filter retains groups whose measure values satisfy a condition, regardless of how many groups qualify.
Answer: It means Tableau evaluates the total of Sales at the relevant level of detail and applies the filter condition to those aggregated values.
Answer: Adding or removing dimensions can change the level of detail at which measures are aggregated. The filter then evaluates different groups or aggregated values.
Answer: A context filter establishes a primary subset of data for other filters in the worksheet. It is useful for particular filtering workflows, including some Top N analyses.
Answer: In Tableau's common filter order, dimension filters execute before measure filters.
Answer: Dimension filters are often compared to WHERE clauses, while measure filters on aggregated values are often compared to HAVING clauses. This is a useful analogy, not a complete equivalence for every Tableau feature.
Dimension and measure filters are essential Tableau features for creating focused, meaningful, and interactive visualizations. Dimension filters help analysts select categories and members, while measure filters help them retain numerical results that satisfy specific criteria. When both filter types are used correctly, analysts can create reports that answer business questions more clearly and accurately.
To improve your Tableau skills, practice both filter types with sample datasets, experiment with different aggregations, and observe how filter order and level of detail affect your results.
Explore Tableau training to strengthen your data visualization, reporting, dashboard creation, and analytics skills.
Interested in learning more? Register for a course demo to explore the training before enrolling.
Register for a Tableau Course Demo
