What is a measure in Tableau and BI?
Quick answer
A measure is a numeric field that a BI tool summarizes, such as revenue, quantity, hours or cost. On a chart it becomes the length of a bar or the height of a line, and it is always shown with an aggregation such as SUM, AVG or COUNT.
Last updated
Updated · By Robert Breen
Why it matters
Measures are the "how much" of a business: how much was sold, spent or delivered. Because a chart groups many rows into each bar, a measure has to be combined somehow, and the aggregation you pick changes the answer.
Choosing SUM when you meant AVG (or the other way round) is one of the most common reasons two dashboards disagree. Labeling the aggregation in the chart title ("Total revenue", "Average order value") prevents most of these arguments.
A worked example
A marketing agency logs time entries: Client, Consultant, Date and Hours. Hours is the measure. SUM(Hours) by client shows Client A at 126 hours this month and Client B at 48. AVG(Hours) by consultant shows the typical entry length (2.1 hours), which answers a different question about how people log time.
To get a utilization rate, you need two measures: billable hours divided by available hours. That ratio is built as a calculated field, so it is computed after summing, not averaged row by row.
Often confused with
Measure vs metric
People use these interchangeably. Strictly, a measure is a raw numeric column (revenue), and a metric is a defined business number, often built from measures (revenue per customer). A KPI is a metric tied to a goal.
Measure vs dimension
A dimension splits the data; a measure gets summarized within each split. ZIP codes are numbers but are dimensions.
Measure Names and Measure Values
Tableau adds two special fields so you can show several measures side by side in one table. They are a convenience, not columns in your data.
Tips
- Put the aggregation in the title: "Total", "Average", "Median".
- Build ratios as calculated fields from summed parts, never by averaging per-row ratios.
- Check one bar by hand against the raw data the first time you build a chart.
Related terms
Learn it in a free lesson
- What Is Business Intelligence? A Beginner’s Guide (about 8 minutes)
- Dimensions vs Measures in Tableau, With Examples (about 9 minutes)
Questions about it
- Should I learn Tableau or Power BI first?: Learn the BI tool your employer, or the one you want, uses. If none, Tableau on a Mac or Power BI on Windows. The core ideas transfer…
Related in the AI glossary
Frequently asked questions
- What is the default aggregation for a measure in Tableau?
- SUM. You can change it by right-clicking the green pill and choosing Measure, then a different aggregation such as Average or Median.
- Is count a measure?
- Counting is an aggregation. Tableau gives every data source a count of records, and you can COUNTD (count distinct) any dimension, such as Order ID.
- Why is my measure showing as a blue pill?
- It has been set to discrete, so it shows as headers instead of an axis. Right-click it and choose Continuous.
All business intelligence terms, A to Z · Free business intelligence lessons