📏Measure

NEW

A numerical value aggregated or computed from data, evaluated within a query’s filter context.

DESCRIPTION

Measures represent quantitative calculations used in analytics, such as sums, averages, or ratios. They are evaluated in context, combining filters from dimensions, slicers, or queries. In tabular models, measures are defined with DAX; in multidimensional models, MDX is common. Measures underpin KPIs and dashboards by standardizing calculations across reports. Clear governance of measure definitions ensures consistent business metrics.

ALTERNATIVE DEFINITIONS

Microsoft Learn

A measure is a formula that is evaluated in the context of the data in your model.

Highlights evaluation within filter context—a key semantic modeling concept.

Source

Microsoft Learn

Measures are calculations performed on data, usually numeric, and are the central values of interest in a cube.

Emphasizes measures as central numeric values within cubes.

Source

IBM

A measure is a numeric data item that can be aggregated.

Defines measures by their aggregative nature in BI tools.

Source

RELATED TERMS

Key Performance Indicator Aggregation Fact Calculated Measure DAX MDX Semantic Model Cube

COMPETING TERMS

Dimension

RELATIONS

• Narrower: Dissimilarity Measure Explicit Measure Implicit Measure

KNOWLEDGE AREAS

Data Warehousing & BI Data Visualization Data Modeling

TARGET AUDIENCE

BI Specialist Data Analyst Analytics Engineer Data Modeler

EXTERNAL SOURCES

• Wikipedia - OLAP#Measures and dimensions
• Microsoft - Power BI measures overview
• IBM - Cognos measures documentation

TOP QUESTIONS

How is a Measure different from a Dimension?

A measure is a numeric calculation aggregated across dimensions; dimensions define the contextual categories like time or product.

Category: Comparison

What language defines Measures in Power BI?

Measures are defined using DAX, a formula language optimized for analytical modeling.

Category: Tools

Why standardize Measures across reports?

Consistent measures prevent conflicting numbers and ensure trust in dashboards and KPIs.

Category: Relevancy

What are common mistakes with Measures?

Ignoring filter context, mixing row and filter context incorrectly, and using implicit measures lead to inconsistent results.

Category: Mistakes

How do Measures support KPIs?

Measures define the underlying calculations for KPIs, enabling consistent thresholds and comparisons.

Category: Concept

Can Measures be non-numeric?

Measures generally return numeric results; textual outputs are uncommon and tool-dependent.

Category: Misunderstanding

What is filter context for a Measure?

It’s the set of filters applied by visuals, slicers, and relationships that determine how a measure is evaluated.

Category: Concept

How to improve Measure performance?

Use efficient aggregations, reduce cardinality, optimize relationships, and avoid overly complex iterators.

Category: Performance

Where should Measures live in a model?

Best practice is to place them in a dedicated measures table or in relevant fact tables for clarity.

Category: Best practices