Related not working while m:m relationship

[nj17]

Hi Team,

I am trying to create a calculate column by using Related but it shows me below error.I already have a relationship between these 2 columns itemname:

Thanks,

nj

[amitchandak · Accepted solution]

@nj17 , related will work only from 1 to Many side

you can try

sumx(relatedtable(Sales), Sales[Sales])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8