CREATE MEASURE statement

CREATE MEASURE statement (MDX)

 

Updated: March 2, 2016

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.

MDX Data Definition Statements (MDX)

Community Additions

ADD
Show:
© 2016 Microsoft