RELATED in a Query

Solution: RELATED in a Query

In DAX, columns have lineage. Knowing when lineage is maintained in a DAX expression and when it is not, is an important skill to write effective code. As a general rule, column references maintain lineage whereas expressions lose it. This puzzle is a single and simple question, but you have to find the exact answer.

Easy solution this time! The result is sales sliced by category and color.
RELATED and Lineage 2
While it is true that RELATED looks like a function, in reality it is not. Using RELATED lets you have access to the expanded columns of a table, but the result of RELATED is still a valid column reference that maintain lineage.

This is the reason why you can write RELATED ( Product[Unit Price] ) + 1, whereas you cannot write RELATED ( Product[Price] + 1 ). The former is a column reference, to which you add 1. The latter, if allowed by the language, would not be a valid column reference, but turns the result of RELATED into an expression.