Wrong sub totals and same row

Question

Hi All,&nbsp;I have problem with subtotal of matrix report.&nbsp;My measure is like below but in the report I am getting like this. Same row number and wrong sub totals&nbsp; with customer name.Thx for your assist&nbsp;2005 = SUMX(VALUES('Order'[PArtno]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RELATEDTABLE('BOM'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ('BOM'[Whs]&lt;&gt;"MSSL"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BOM'[whs2]="2005")&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RIGHT('BOM'[SubParts],3)="IS1"||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RIGHT('BOM'[SubParts],3)="IS2"||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RIGHT('BOM'[SubParts],3)="IS3"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ('Bom'[Qty]&nbsp;*&nbsp;'Bom'[Weight])/1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; * [rate]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )

greg_deckler · Answer

OzgurKlc&nbsp;Seems like there may be a missing relationship between your tables.

greg_deckler · Answer

OzgurKlc&nbsp;Well, that would also suggest a potential missing relationship. What does the data model look like?

ozgurklc · Answer

Hi&nbsp;Greg_Deckler&nbsp;&nbsp;,It is working well when I remove the company name ( it is in order table with part code) measure from the rows . any suggest?

ashish_mathur · Answer

Hi,
Share some data to work with and clearly show the expected result.

ozgurklc · Answer

&nbsp; order table and bom table&nbsp; have many to many and btw bom and stock balance(qty) have many to many.

Forum Discussion

Wrong sub totals and same row

5 Replies

Related content

Wrong Total

Wrong Total in Table

Wrong total

Total measures show wrong total when report is published

wrong total