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.