Forum Discussion
Getting a correct sum when having multiple rows and multiple tables
Hello, I could not find the answer to my inquiry- if it already exists, I would very much appreciate a link. I am pretty new to this so would appreciate any help I can get. I have one table of ...
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Ok - here is try:
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
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)