Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Related

Hi,   I have two tables but they aren't in a direct relation (just an inactive). Is there a possibility to get the Related Function into action even without direct relation? Thanks a lot. 
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi amitchandak 

    The Relationship meets at another table. But I figured out there was another table i could make a relation with (a date table) and after that, i used the relatedtable function with sumx and that worked out with a charm. But good to know: userelationship.

    Hi PaulDBrown 

    Thanks for the reply. Since I could use the relatedtable function with sumx, everything works fine. But that's a great way with a virtual table.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  Anonymous ,

According to your description, I created two unrelated tables:

Here are the steps you can follow：

1. Create calculated column. Use the relatedtable function in table2 to calculate the amount in the table

Column = SUMX(RELATEDTABLE('Table'),'Table'[amount])

2. Result

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.