Powerbi total sum many to many issue

[noisyboey10]

Hello Good day ladies and gentleman,

I'm facing this total sum issue for my table visual. 

I've this 4 tables with multiple columns. Lets call it Table A,B,C,D

A(1<->*)D, A(1->*)C ,B(1->*)C

Primary key - ID

note- Table D is the sales table and its ID key is in the form, ID1, ID2, ID1_ID2_3, ID4, ID5_ID6 etc. but for the remaining tables IDs are in the form ID1, ID2, ID3, etc.

So, now when I pull columns from all these 4 tables the table visual should look something like 

BID(tableC)   mfg.site(tableC)   ID(tableA)    category(tableB)     sales(tableD)

BID1                greece                 ID1                   catA                    54

BID2                 turkey                 ID1                    catB                    7

BUT

Im getting 

BID(tableC)   mfg.site(tableC)   ID(tableA)    category(tableB)     sales(tableD)

BID1                greece                 ID1                   catA                    61(54+7)

BID2                 turkey                 ID1                    catB                   61(54+7)

Why is this happening? And what are the next steps should I take to get the desired output? i.e sales for individual mfg site?

Thanks for reading this. Much appreciated 

Please ask me questions for further clarification.

[v-priyankata]

Hi  @noisyboey10
Thank you for reaching out to the Microsoft Fabric Forum Community.

@VijayP Thanks for the inputs.
As suggested by user, 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? 

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Thanks.

[v-priyankata]

Hi  @noisyboey10
Thank you for reaching out to the Microsoft Fabric Forum Community.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

[VijayP · Accepted solution]

@noisyboey10  Looks like there is a datamodel issue. Table primary keys and foreign keys might not be matching.

let me have some sample data then I can resolve , becasue the data point shown in the explanation is bit confusing.