Wrong Sub Total

[Anonymous]

Hi All, 

i am having trouble getting correct subtotal in the unit price calculation shown in the picture. The numbers below the subtotal works fine but the total is wrong it should have been 5,856,787 instead of the current 9,898,119. The measuer i sued to calculate is pretty straight forward which is:

Unit Price = ([LE3(Price)]-[Actual(Price)])*[Vol. Brewed Actual 2]*[Actual (con. per hl)]

and unit price depends on the following measures:

1.LE3(Price) = DIVIDE([LE3],[LE3(per unit)])

2.Actual(Price) = DIVIDE([Actual],[Actual(per unit)])

3.Volume Brewed LE2 = CALCULATE(SUM('FCT_Wort Volume'[Volume in (hl)]),'FCT_Wort Volume'[Version]="LE3",'FCT_Wort Volume'[PLLI Description]="Volume Brewed",ALL('Raw Materials'[Item Description]))

4.Actual (con. per hl) = DIVIDE([Actual(per unit)],[Vol. Brewed Actual 2])*-1

5. LE3 = CALCULATE(SUM('FCT_Raw Material'[Amount]),'FCT_Raw Material'[Version]="LE3")

6. LE3(per unit) = CALCULATE(SUM('FCT_Raw Material'[Quantity],'FCT_Raw Material[Version]="LE3")
7. Actual = CALCULATE(SUM('FCT_Raw Material'[Amount]),'FCT_Raw Material'[Version]="Actual",'FCT_Raw Material'[Type ]="Raw Material",'FCT_Raw Material'[Entry Type]="Consumption") 

The file only uses one table which is why i didn't need a table reference in most of the calculations.

Please help me in fixing the subtotal for the unit price.

KR,

Ermias

[Anonymous · Accepted solution]

Hi @Anonymous ,

It seems like a common measure calculation issue on total level.(when measure calculated on total level, it will direct calculated with summary row contents instead of calculate drill to detail row and summary calculation result)

For example:
Detail level: 2*3,3*4,5*6
Total level: (2+3+5)*(3+4+6)

You can take a look at following link to know more about this:

Measure Totals, The Final Word

Regards,

Xiaoxin Sheng