Rules / DAX Expressions

Column references should be fully qualified

error DAX_COLUMNS_FULLY_QUALIFIED · ported · scope: Measure, TablePermission, CalculationItem

What it checks

Measures and row-level security filters that refer to a column by its bare name, [Column], instead of 'Table'[Column].

Why it matters

In DAX a bare [Name] is the convention for a measure. A column written the same way reads as a measure to everyone who maintains the model, and the two behave differently in a row context, so the expression is misread before it is ever debugged. The bare form also breaks when the column moves to another table, or when a measure with the same name is added and the engine binds to that instead.

How to fix it

Write 'Table'[Column] for every column reference. The formula bar in Power BI Desktop completes the qualified form when you start typing the table name.

Quirks

Links

Check a model for this Improve this page