Export (0) Print
Expand All

CREATE MEASURE statement (MDX)

Creates a measure in a Tabular Model.

CREATE MEASURE Table_Name[Measure_Name] = DAX_Expression
[; CREATE MEASURE ...n]

Table_Name

A valid string literal that provides the name of the table where the measure will be created.

Measure_Name

A valid string literal that provides a measure name.

DAX_Expression

A valid DAX expression that returns a single scalar value.

The Measure_Name must be enclosed in square parenthesis.

The CREATE MEASURE statement can only be used inside of a MDX script definition; see MdxScript Element (ASSL).

You can also define a calculated member for use by a single query. To define a calculated member that is limited to a single query, you use the WITH clause in the SELECT statement. For more information, see Building Measures in MDX.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft