Incorrect Total

[Nun]

Hello,

I have these formulas:

Actual LC = calculate(sum('Cost Item'[Amount in Local Currency]), 'Cost  Item'[After Or Pre]="After")

because there value in "Amount in Local Currency" with Cist Item[After Or Pre] = "Pre")

Budget LC = CALCULATE(SUM('Cost  Item'[Amount in Local Currency]), 'Cost  Item'[After Or Pre]="Pre")

Budget Eur = CALCULATE(SUM('Cost  Item'[Amount in EUR]), 'Cost  Item'[After Or Pre]="Pre")

based on those last two formula I calculate a currency formula

Budget calculation rate = DIVIDE([Budget LC],[Budget EUR],0)

last but not least formula:

Act value = DIVIDE([Actual LC],Budget calculation rate,0)

All the measures are correct, the values are correct as well the totals except the total of the last formula (Act value).

The single value of each row for the formula Act value is correct, but the total is incorrect.

I tried to add a new formula sumx = ('Cost  Item',[Act value]) but doesn't work.

Thank you in advance!

[amitchandak · Accepted solution]

@Nun , You need to some intermediate  grouping if you want sum

like sumx(values('Cost Item'[?]),[Act value]) 

where ? is level/column/group by after which you want sume 

Refer this video:https://www.youtube.com/watch?v=4xn0A43jBz8&t=122s

[Nun]

Hi @amitchandak 

thank you so much!

I tried some columns in the fuction "values" and I found the correct one, thanks!