problem with relation between table (newbie)

[earthoer]

i have relation like these. In table projectdata I canuse related to salesName but I cannot  use related  to projectsubdata (I try to typing but it show nothing )

And second problem  

if I related to userdata- sales it can related but show nothing.

thank

[ALLUREAN]

Hi, @earthoer 

You need to follow the star schema or snowflake schema in your data model. In your case you probably have more than 1 fact tables. In order to get correct results it is good to follow it. You can use LOOKUPVALUE instead of RELATED but this will not be a solution and maybe will cause some issues with data.

[amitchandak]

@earthoer , Based on what I got. Related can only be used from 1 side to many side. You can create new column on Many side .

You can try relatedtable for 1 side

example

sumx(relatedtable(projectData]),[Est Fee])

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