Can't get a related column

[wpf_]

I have table A and table B.  They are related via the fields tableA(dayOff) and tableB(value).   dayOff is a calculated column and value column is built from a calculated table B.  

I tried several approaches to try to get 'value':

1)calculated column in table A:    RELATED(table B[value])

I get error: the column table[value] either doesnt exist or doesnt have a relationship to any  table available in the current context. Table A is the many side and table B is the one side.  I can clearly see and select table[value] in the RELATED function. 

2)in a measure

FILTER(

ADDCOLUMNS(

SUMMARIZE(

tableA,

"column1",

"column2"

),

"dayOffValue", minx(tableB, related(tableB[value]))

),

filter statements

)

With this approach, when typing related, the columns do not pop up.  

------------------

What am i doing wrong, how can i get value over from table B into table A?  The relationships are active and its a many to one.  Many on the table A side.  Thanks 

[PVO2]

minx(tableB, related(tableB[value])

With above syntax youre already iterating the table. So the related function is not needed. If multiple values are returned you might need an arregation.

[richbenmintz]

Hi @wpf_ ,

Can you please provide some sample data?

[wpf_ · Accepted solution]

@richbenmintz 

So from reading through forums, the issue is with mix table types and there seems to be a bug using relate when having directquery and other types of tables.  Thanks.