Rules / Error Prevention

Expression-reliant objects must have an expression

error EXPRESSION_RELIANT_OBJECTS_MUST_HAVE_AN_EXPRESSION · ported · scope: Measure, CalculatedColumn, CalculationItem

What it checks

Measures, calculated columns, and calculation items whose expression is empty.

Why it matters

Without an expression the object cannot be evaluated: a measure returns nothing, a calculated column is empty, and a calculation item does nothing. Depending on the engine version the deployment fails outright, and the error points at the object without saying why.

How to fix it

Add the DAX, or delete the object.

Quirks

Links

Check a model for this Improve this page