Skip to content
BENIBIX Learn

Measure (Analytics)

Data📊 Analytics & BISemantic Layer

Also known as Measure, Aggregate Measure, Business Metric

A number you add up or count, like revenue. You split it by dimensions.

Think of it like

You count the apples in a basket. That count is a measure. Split them by color, and color is the dimension.

Example

Revenue is a measure, and country is a dimension. Revenue by country is a chart with one bar for each country.

Why it matters

Most arguments about numbers come from two people summing in two ways. A shared measure ends that.

Definition

A measure is a number that is added up, counted or averaged, such as revenue or the number of orders. A dimension is a field you group by, such as country or month. A chart puts the two together: revenue by month. Measures are defined in a semantic layer or a BI model. The rule is written once, then used in every chart.
Revenue in the middle box is a measure. Country and month beside it are dimensions.

Common mistake

Adding up a number that cannot be added, such as an average. The sum of averages is not the average of the total.

Key takeaways

  1. 1
    A number. Summed, counted or averaged.
  2. 2
    Split by dimensions. Country, month, product.
  3. 3
    Defined once. One rule, every chart.