Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Incorrect Totals for Measures

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
Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
       

      Hi JirkaZ,

       

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

       

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    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.