Forum Discussion
Multiplying between Tables
Just to clarify on 1 to many relationships:
* From the "Many" side, you can use RELATED(OneSideTable[Field]) just fine. As there is... only 1 row that will match.
* From the "One" side, you can use RELATEDTABLE(ManySideTable) as get all rows associated with the one side... and do something w/ those rows. eg: =SUMX(RELATEDTABLE(ManySideTable), ManySideTable[Price])
Thank you but in this situation I don't think I can Sum or Average the Unit Price and get the desired results. Sorry I did mean "multiply columns". I also changed Qty To Pick as numeric but I'm no closer.
Another question I have is since there is a relationship why isn't the Related() function working. I could just pull over the Unit Price into the table with Qty To Pick then just multiply them in a new column. For Example why doesn't this work:
in the p21_view_mt_pix_tix_detail table create a new column:
=Related('p21_view_oe_line[Unit Price])
I figured out the problem. For future reference. I have a Many-to-One relationship between these tables.
One - p21_view_mt_pix_tix_detail
Many - p21_view_oe_line
I was unaware you can not call a Many table into a One table. I'm pulling everything into the Many table and that seems to be working for me.
Just to clarify on 1 to many relationships:
* From the "Many" side, you can use RELATED(OneSideTable[Field]) just fine. As there is... only 1 row that will match.
* From the "One" side, you can use RELATEDTABLE(ManySideTable) as get all rows associated with the one side... and do something w/ those rows. eg: =SUMX(RELATEDTABLE(ManySideTable), ManySideTable[Price])
I need a similar solution but I have Many to Many relationship.
