Is it possible to use the RELATED() DAX function with a Measure in Power BI?
As per the official Microsoft documentation, the RELATED function needs a row context; therefore, it can only be used in calculated column expression, where the current row context is unambiguous, or as a nested function in an expression that uses a table scanning function. A table scanning function, such as SUMX, gets the value of the current row value and then scans another table for instances of that value.
So in your Measure, if you are using the
CALCULATE function that removes the row context, you will not be able to use the
RELATED function because the row context is no longer available, and in this case, you have to use the
Filter expression to define the row context and to be able to use the
RELATED function as below:
Measure = calculate( sum('Product List'[Sold]),FILTER('Product List', RELATED('Product Price (RELATED)'[ProductKey]) = 1 ))
Alternatively, you can create a calculated column that holds the related value,
Calculated Column(RELATED) = RELATED('Product Price (RELATED)'[Price])
Then use this column in your Measure as below:
Measure = sum('Product List'[Calculated Column(RELATED)])
Read more at Power BI: RELATED Vs LOOKUPVALUE DAX