Issue with relationship

[VitorPereira]

Hi, I'm not sure why I can't use relate function to one of my tables. Basically everything looks good between the relationship. This is the context: In table "interaction_source" I need to create a column to bring the "task" column in "Interactive_Related" table, so I'm using. 

Related task = RELATED(Interactive_Related[task])

This is because I need to count blank values that will come in interaction_source new column, that's why this is a *:1.

I notice that when I type the Related function it's not populating the options of the related table, indicating some issue on the relationship. Can someone help to find out why it's getting this issue??

[Daniel29195 · Accepted solution]

@VitorPereira 

if you are creating a column in the table at the many side of the relationship, use RELATED 

if you are creating a colum in the table at the one side of the relationship , you should use relatedtable .

NB : relatedtable returns a table , so you need to use relatedtable with an iterator or countrows()  etc.. . 

let me know if that works for you .

If this answers your question  ,  mark it as the solution ✅ so can you can help  other people in the community find it easily .