Forum Discussion

sophie63's avatar
sophie63
Icon for Helper I rankHelper I
9 years ago

Using RELATED()

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 MPPAYER...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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