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.

DEFINE
EVALUATE
VAR
DAX queries