Incorrect Totals for Measures

[Anonymous]

Hi Folks,

I have read and applied almost all relevant post for Incorrect totals related to measure but still the issue persists. I have two tables having many to many relationship(due to which I cannot use related function) - A containing quantity information for items and B containing prices for those items. Tables are big so i don't want to merge them. I have resolved many to many relationship using bridge table to many to one relationship however, when I use calculated columns to calculate the item cost, it gives error of circular dependency.

To avoid that I tried to do the calculation using measures but it results in incorrect totals. Any pointers to resolve the issue is much appreciated!
Formulas that is have used for measures -

Part Cost = 

SUM('A'[Component quantity]) * SUM('B[Current price])

Cost =

var temp = SUMX(VALUES('Bridge Table_item list'[Index_Bom]),Part Cost)

var temp1 = SUMMARIZE(A,A[Index_Bom],"Cost",temp)

var result = IF(ISFILTERED(A[Index_Bom]),Part Cost,SUMX(temp1,[Cost]))

return result

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You can refer to the blog:Measure-Totals-The-Final-Word 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JirkaZ]

@Anonymous Can you show your model? 

[Anonymous]

Hi JirkaZ,

Below is the snippet of datamodel. I have highlighted the column that i want to multiply in the measure.