2.2.5.30 CalculationItem Object

The CalculationItem object represents a value that is calculated based on an expression. It is a child of a CalculationGroup object and requires compatibility level 1500 or higher.<84>

The CalculationItem object has the following properties.

Name

Type

Description

ID

unsignedLong

A reference to the object.

CalculationGroupID

unsignedLong

An ID-based reference to a CalculationGroup object.

FormatStringDefinitionID

unsignedLong

An ID-based reference to a FormatStringDefinition object.

Name

string

The name of the object.

Description

string

The description of the object.

ModifiedTime

dateTime

The time that the object was last modified.

State

enumeration

A value that provides information about the state of the calculation item. The possible values are as follows:

  • Ready (1) – The calculation item is queryable and has up-to-date data.

  • NoData (3) – Not applicable to CalculationItem.

  • CalculationNeeded (4) – Not applicable to CalculationItem.

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

  • EvaluationError (6) - Not applicable to CalculationItem.

  • DependencyError (7) – A dependency associated with this calculation item is in an error state (SemanticError, EvaluationError, or DependencyError).

  • Incomplete (8) - Not applicable to CalculationItem.

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

ErrorMessage

string

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

Expression

string

The DAX expression that is evaluated for the calculation item.

Ordinal

int

The zero-based ordinal value that is associated with a calculation item. This value is meant to be used as the ordering column in the DAX query.