MEASURE
Introduces a measure definition in a DEFINE statement of a DAX query.
Syntax
[DEFINE
(
MEASURE <table name>[<measure name>] = <scalar expression>
) +
]
(EVALUATE <table expression>) +
Parameters
Term | Definition |
---|---|
table name | The name of a table containing the measure. |
measure name | The name of the measure. It cannot be an expression. The name does not have to be unique. The name exists only for the duration of the query. |
scalar expression | A DAX expression that returns a scalar value. |
Return value
The calculated result of the measure expression.
Remarks
Measure definitions for a query override model measures of the same name for the duration of the query. They will not affect the model measure.
The measure expression can be used with any other expression in the same query.
To learn more about how MEASURE statements are used, see DAX queries.
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for