Forum Discussion
Adding a column from a related table
I have two tables with one-to-many relationship between them. One is an 'orders' table and the other is 'details' table. Orders table have unique OrderIDs while the Details table can have non-unique...
Create a calculated column like below in Order Table.
_Total Sales = CALCULATE(SUM('Table (2)'[sales]))
Hi, I saw this on another thread on here and tried it and it didn't work. I get an error saying that the tables aren't related even when I made sure that there was a relation between the two tables. I am guessing it does that cause of the one-to-many cardinality. Thanks for your response.
No, Related will not work for the use case given, which clearly states summing values from the many-side to the one-side. Relatedtable or calculatetable should work for you instead. Related only works when trying to get values from the one-side to the many-side.