Share via

Level Element (CSDL)

  • Article

The Level element defines the data source of a single attribute in a hierarchy

The Level element can have the following child elements (in the order listed):

  • Documentation Element

  • SourceProperty Element

Applicable Attributes

The following table lists the attributes that can be found on the Level element.

Attribute Name

Is Required

Value

ReferenceName

Yes

The identifier used to reference the level in a DAX query.

Caption

No

The display name for the level.

Remarks

For more information about hierarchies in tabular models, see Hierarchy Element (CSDL).

Example

The following example shows the definition of multiple levels in a hierarchy from the AdventureWorks tabular model sample.

<bi:Hierarchy>
    <bi:Level>
      <bi:Source>
        <bi:PropertyRef name="Calendar_Year" />
      </bi:Source>
    </bi:Level>
    <bi:Level>
      <bi:Source>
        <bi:PropertyRef name="Calendar_Semester" />
      </bi:Source>
    </bi:Level>
    <bi:Level>
      <bi:Source>
        <bi:PropertyRef name="Calendar_Quarter" />
      </bi:Source>
    </bi:Level>
    <bi:Level>
      <bi:Source>
        <bi:PropertyRef name="Month_Calendar" />
      </bi:Source>
    </bi:Level>
    <bi:Level>
      <bi:Source>
        <bi:PropertyRef name="Day_Of_Month" />
      </bi:Source>
    </bi:Level>
  </bi:Hierarchy>
  <bi:Hierarchy>

See Also

Concepts

Understanding the Tabular Object Model

Understanding Functions for Parent-Child Hierarchies in DAX

Configure the (All) Level for Attribute Hierarchies