Incorrect Total

Question

Hello,I have these formulas:Actual LC =&nbsp;calculate(sum('Cost Item'[Amount in Local Currency]), 'Cost&nbsp; 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&nbsp; Item'[Amount in Local Currency]), 'Cost&nbsp; Item'[After Or Pre]="Pre")Budget Eur = CALCULATE(SUM('Cost&nbsp; Item'[Amount in EUR]), 'Cost&nbsp; Item'[After Or Pre]="Pre")based on those last two formula I calculate a currency formulaBudget calculation rate = DIVIDE([Budget LC],[Budget EUR],0)last but not least formula:Act value = DIVIDE([Actual LC],Budget calculation rate,0)&nbsp;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&nbsp; Item',[Act value]) but doesn't work.Thank you in advance!&nbsp;&nbsp;&nbsp;&nbsp;

amitchandak · Accepted Answer

Nun , You need to some intermediate&nbsp; grouping if you want sum 
&nbsp;
like sumx(values('Cost Item'[?]),[Act value])&nbsp;
where ? is level/column/group by after which you want sume&nbsp;
&nbsp;
Refer this video:https://www.youtube.com/watch?v=4xn0A43jBz8&amp;t=122s

Forum Discussion

Incorrect Total

2 Replies

Related content

Incorrect turnover total

Measure Total Incorrect

Matrix Totals Incorrect

Incorrect total

Incorrect Total