Related function issues

[Anonymous]

Hi,

I'm trying to use the related function in tableB which looks like this

age = related(tableA'age')

Also, both the tables are joined based on a key column.

Still, the related function doesn't show the age column automatically and the above-caclulated column throws an error.

[v-yuta-msft]

@Anonymous ,

You'd better nest the RELATED() function into a FILTER() statement, then implement the table scanning function. Please refer to doc about RELATED().

https://docs.microsoft.com/en-us/dax/related-function-dax

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi Jimmy and Parry,

Thanks for your replies.

Here is when the related function started working.

Sorry, I couldn't share the client data model, but when I used related function in the primary fact table it works.

When I was trying to create that in dimension table I was getting the above error.

[parry2k]

@Anonymous that make sense, fact will be on the many side of the relationship and dim is on one side for the relationship and that's exactly my first reply was, not sure why you think it started working now. 

[Anonymous]

Thanks let me try this today

[parry2k]

@Anonymous related will show column from one side of the relationship. How your these two tables are related? Share relationship diagram.