DataTerminology.comNEW
Also known as: Derived Measure
A measure automatically created by a BI tool from aggregated columns without an explicit formula in the model.
DESCRIPTION
Implicit measures are auto-generated aggregations created by BI tools when a numeric column is placed in a visual with a default aggregation. They speed ad‑hoc analysis but reduce control over semantics, naming, and reuse. Implicit measures typically cannot be reused across visuals or benefit from advanced DAX expressions. Teams building governed metric layers prefer explicit measures for consistency, documentation, and testing. Migrating from implicit to explicit measures improves maintainability and clarity in enterprise models.
ALTERNATIVE DEFINITIONS
Microsoft Learn
Implicit measures are created by Power BI automatically when you place a field in a visual and an aggregation is applied.
Highlights automatic creation triggered by adding fields with aggregations.
SQLBI
An implicit measure is an aggregation defined in a visual over a column, without a DAX definition stored in the model.
Emphasizes lack of a reusable DAX definition in the model.
RELATED TERMS
Measure DAX Aggregation Power BI Tabular Model Fact Star Schema Calculated Columns Semantic Layer
COMPETING TERMS
RELATIONS
- Broader: Measure
KNOWLEDGE AREAS
Data Warehousing & BI Data Modeling Data Visualization
TARGET AUDIENCE
BI Specialist Data Analyst Analytics Engineer Data Modeler
EXTERNAL SOURCES
TOP QUESTIONS
When should Implicit Measures be used?
Use implicit measures for quick exploration and ad‑hoc analysis. For governed dashboards and shared models, prefer explicit measures with clear logic and documentation.
Category: Practice
What is a downside of Implicit Measures in enterprise BI?
They hinder reuse and consistency because logic is bound to visuals. This increases maintenance and risks metric drift across reports.
Category: Risks
How do Implicit Measures affect performance?
They can perform similarly to simple explicit measures, but complex business logic requires explicit measures for optimization and caching advantages.
Category: Performance
Can Implicit Measures be documented?
Documentation is limited because the formula is not stored in the model. Switching to explicit measures enables versioning and lineage.
Category: Governance
How do Implicit Measures relate to DAX?
Implicit measures do not have explicit DAX expressions. Explicit measures use DAX, enabling advanced calculations and clarity.
Category: Relation
What is a common mistake with Implicit Measures?
Relying on default aggregations (e.g., sum) without considering business rules leads to incorrect insights.
Category: Mistakes
How to convert an Implicit Measure to an Explicit Measure?
Create a named measure with DAX that defines the intended aggregation and use it consistently across visuals.
Category: HowTo
Why do teams discourage Implicit Measures?
They reduce transparency and reuse, complicating quality assurance. Explicit measures support testing and shared understanding.
Category: Opinion
What is a competing concept to Implicit Measures?
Explicit Measures are the preferred alternative for governed reporting because they centralize logic and enable reuse.
Category: Alternatives