Forum Discussion

sophie63's avatar
sophie63
Helper 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 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?

Need Help

3 Replies

Replies have been turned off for this discussion
  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft 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


     

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    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