2.2.5.28 DetailRowsDefinition Object

The DetailRowsDefinition object represents an unnamed table expression in DAX. It is a child of a Measure or a Table object and requires compatibility level 1400 or higher.<82>

The DetailRowsDefinition object has the following properties.

Name

Type

Description

ID

unsignedLong

A reference to the object.

ObjectID

unsignedLong

An ID-based reference to a Measure or Table object.

ObjectType

int

The data type of the object specified by ObjectID. The possible values are as follows:

  • TM_TYPEID_Table (3)

  • TM_TYPEID_Measure (8)

Expression

string

The DAX detail rows expression for a table type.

ModifiedTime

dateTime

The time that the object was last modified.

State

enumeration

A value that provides information about the state of the parent object or the container object. The possible values are as follows:

  • Ready (1) – The object expression is queryable and the data is in an up-to-date state.

  • NoData (3) – Not applicable.

  • CalculationNeeded (4) – Not applicable.

  • SemanticError (5) – The object expression has a semantic error.

  • EvaluationError (6) - Not applicable.

  • DependencyError (7) – A dependency associated with the DetailRowsDefinition object is in an error state (SemanticError, EvaluationError, or DependencyError).

  • Incomplete (8) - Not applicable.

  • SyntaxError (9) – The object has a syntax error in its expression.

ErrorMessage

string

A string that explains the error state that is associated with the DetailRowsDefinition object. It is set by the engine only when the state of the object is one of these three values: SemanticError, DependencyError, or SyntaxError.