DataTerminology.comNEW
Also known as: Stored Measure
A named, reusable measure with an explicit formula defined in the data model.
DESCRIPTION
Explicit measures capture business logic as named expressions in the semantic model, enabling reuse, documentation, and governance. They typically use languages like DAX and appear consistently across visuals and reports. Centralizing metric definitions reduces drift and improves testing, lineage, and change control. Explicit measures are recommended for enterprise BI and metric layers. They can leverage advanced calculations, filter context, and time intelligence for robust analysis.
ALTERNATIVE DEFINITIONS
Microsoft Learn
An explicit measure is created by you and stored in the model with its own name and DAX formula.
Stresses authoring, naming, and persistence in the model.
SQLBI
An explicit measure is a DAX measure defined in the model that can be reused across multiple visuals and reports.
Highlights reusability and central definition in the model.
RELATED TERMS
Measure DAX Semantic Layer Power BI Tabular Model Calculated Columns Aggregation Metric Layer Data Discovery Platform
COMPETING TERMS
RELATIONS
- Broader: Measure
KNOWLEDGE AREAS
Data Warehousing & BI Data Modeling Data Visualization Metadata Management
TARGET AUDIENCE
BI Specialist Analytics Engineer Data Modeler Data Analyst
EXTERNAL SOURCES
TOP QUESTIONS
Why prefer Explicit Measures over Implicit Measures?
Explicit measures centralize logic, enable reuse, and support documentation and testing. This improves reliability and governance across reports.
Category: Relevancy
How do Explicit Measures aid data governance?
They make metric definitions visible and versionable, enabling lineage tracking, code review, and change control in semantic models.
Category: Governance
Are Explicit Measures always better for performance?
Not always, but they allow optimized DAX expressions and consistent filters, which can improve performance in complex scenarios.
Category: Performance
Can Explicit Measures be shared across datasets?
With shared datasets or metric layers, explicit measures can be reused across reports and teams, reducing duplication.
Category: Collaboration
What is a common mistake with Explicit Measures?
Embedding too much logic in a single measure hurts readability. Compose smaller measures and reference them for maintainability.
Category: Mistakes
How to document Explicit Measures effectively?
Use descriptions in the model, a business glossary, and version-controlled files. Include rationale, data sources, and test cases.
Category: Documentation
What skills are needed to create Explicit Measures?
Knowledge of DAX (or equivalent), data modeling, filter context mechanics, and domain semantics is essential.
Category: Requirements
How do Explicit Measures interact with filter context?
They evaluate within the current filter context and can modify it using functions like CALCULATE for precise analysis.
Category: Concept
What is a competing concept to Explicit Measures?
Implicit Measures are the alternative, trading governance and reuse for speed of ad‑hoc aggregation.
Category: Alternatives