This topic has not yet been rated - Rate this topic

CREATE MEASURE statement (MDX)

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

Creates a measure in a Tabular Model.

Syntax


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

Arguments

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.

Remarks

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.

Other Resources

MDX Data Definition Statements (MDX)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)