RELATED() Doesn't work - either doesn't exist or doesn't have a relationship to any table available

[some]

Hi, I have this model where there is a relationsship between my calendar and the table "Planzahlen".

This relationship works and I use it in many charts:

https://imgur.com/AgyESVG 

Now I try to create this measure in the table "Planzahlen" to get the related Months:

MonatJahr = RELATED('Kalender_lookup'[Year])

Trying that, I get this error: 

The column 'Kalender_lookup[Year]' either doesn't exist or doesn't have a relationship to any table available in the current context.

Why doesn't it work in this contexts?

Btw, I follow this tutorial 

http://sqljason.com/2018/03/display-last-n-months-selected-month-using-single-date-dimension-in-powe...

Thanks!

Br

[amitchandak · Accepted solution]

@some . Related work in 1- Many relation from one to many side.

a New column  = related(Calendar[Minth Year])

A new measure = maxx(Sales, related(Calendar[Month Year]) )

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[some]

Thank you @amitchandak 

I am an idiot of course I need a column not a measure!! thank you