Using RELATED()

[sophie63]

Hi,

I have an issue when using the RELATED() function. I have a Many to One relationship between the table CON and the table MPPAYERS but when I try to create a calculated colum in MPPAYERS to get data from CON (for instance the column [CON_ID]) I have the following error : The name 'RELATED' wasn't recognized. And when I try to create a measure in my report, dooing the same, I have this error: The XXX column either doesn't exist or doesn't have a relationship to any table available in the current context.

Could you halp me please?

[Phil_Seamark]

Hi @sophie63

I think RELATED() would work if you were creating the column in the CON table (the child table) and trying to refrerence data from the parent table.  Whereas I understand REALATEDTABLE() is used from the parent table, or MPPAYERS in this case.

Cheers,

Phil

[v-huizhn-msft]

Hi @Greg_Deckler,

Because I can not see your detail resource data, I try to reproduce using the following sample table.



In Table, I want to  get Table[QuantityA] value. It returns error when I use RELATED function, there are mutiple Table4 values for each row in Table. I must use a aggregated function. Just as @Greg_Deckler posted, I use the following formula and get expected result.

Result = SUMX(RELATEDTABLE(Table4),Table4[QuantityA])

If you have any issue, please let me know.

Best Regards,
Angelia

[Greg_Deckler]

Try RELATEDTABLE