Getting a correct sum when having multiple rows and multiple tables

Question

Hello,I could not find the answer to my inquiry- if it already exists, I would very much appreciate a link. &nbsp;I am pretty new to this so would appreciate any help I can get.&nbsp;I have one table of order data, in that table there can be several rows with the same order number (on each row I have COGS, sales etc).&nbsp;I want to combine that table with another table where I have logistics cost per order number (those are the only two columns). That table only has one cost per order number. I would like to somehow get a total cost (with COGS + logistics cost) per order number.&nbsp;&nbsp;The two tables have a relationship and I get the total cost (COGS+logistics cost) to work on a total level. Whenever I try to break it down to for instance customer or ordernumber it does not work.&nbsp;&nbsp;Would appreciate any help, have googled like crazy but cant find the right solution.&nbsp;James

anonymous · Answer

InspectahJI suggest you drop some sample of your tables. It is not clear to me. For example, if the tables have relationships, then why do you want to combine them? Based on which filed they have a relationship? Which kind of a relationship they have? one-to-many? Is there a fact table or lookup table in between?&nbsp;

inspectahj · Answer

AnonymousThank you for you time!&nbsp;I created a relationship as I thought that would be enough to get the combined cost to work. There is a one to many relationship right now. Not sure what kind of samples I should provide?&nbsp;I will try to make it clearer:I have two tables. In the first one I have all the order rows from our ERP. On each row there is a ton of data (such as customer, what product, amounts and other). The order number is not unique in this table as an ordernumber can have several rows.&nbsp;The second table has only two columns: ordernumber and cost per ordernumber. In the column ordernumber there are unique values.&nbsp;&nbsp;I am trying to find a way in which I could get a total cost per order number with the data from these two tables. If possible I would like to be able to perform analysis on the total cost per customer or article &nbsp;etc.&nbsp;&nbsp;I have only been doing this for about a month and have an accounting background, so I am sorry if this is a bit blurry from my side...&nbsp;&nbsp;

anonymous · Answer

InspectahJPlease see this post regarding How to Get Your Question Answered Quickly:&nbsp;https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490&nbsp;

inspectahj · Answer

Ok - here is try:&nbsp;The relationship: Two tables are called "transaktioner" and "StorexCostsTotal"Relationship between the two tablesTable1: transaktioner. Showing the COGS value - which I would like to add with the value LogCosts from Table 2: StorexCostsTotal (see next screen shot)Table1: transaktioner. part 1Table2: StorexCostsTotal: ordernumber is unique

inspectahj · Answer

So on a total cost level it works: see below:The total for everything is correctIf I try to divide the data into any categories - it becomes wrong (same amount in every category)

Forum Discussion

Getting a correct sum when having multiple rows and multiple tables

8 Replies

Related content

MULTIPLE CARD

Multiple dataViewMappings

Merge data from multiple excel files from multiple sharepoint folders

Disable multiple eventstreams

IF, Multiple