RELATED column works in calculated column but not in measure, why?

[Ortelli]

I'm learning Power BI and I came across something that I don't understand. I have a 1-* relationship between the table "PI6" and "Progress". If I add a calculated column to the PI6 table, I can set the value equal to the column "Percent" in the Progress table with the function RELATED. But if I try to create a measure and use exactly the same formula Power BI tells me that the column "Percent" doesn't exist or there isn't a relationship to any table available in the current context (s. picture)???

[Pragati11 · Accepted solution]

Hi @Ortelli ,

The RELATED DAX function has a limitation which you can see here:

https://learn.microsoft.com/en-us/dax/related-function-dax#remarks

[Ortelli]

Thank you for the explanation