Total sum of a average measure

[Bruce101995]

Hello,
I have this measure,I am trying to some the values on the column  € Diferença, but it not right.
Can you help me please?

final mesure:

€ Diferença=

 SUMX(VALUES(Calendario[MesNome]),

 [qtd]*[Diff preço real ORCA])

secundary measures 1:

qtd = CALCULATE(SUM('UNION'[Qt Enc Tn]))*1000

secundary measures 2:

Diff preço real ORCA = IF(OR([Real N]= 0, [ORCA N]=0),BLANK(),   [Real N]-[ORCA N])

secundary measures 3:

ORCA N =

var yearNE = CALCULATE(MAX(Calendario[Ano]))

var yearN = SELECTEDVALUE(Calendario[Ano],yearNE)

var orca_amount_YTD = CALCULATE(AVERAGEX('UNION','UNION'[QTD/valor]), 'Union'[Ano] = yearN && 'Union'[Tipo] = "ORCAMP" && 'UNION'[Uni]="Valor" )

return

orca_amount_YTD

secundary measures 4:

Real N =CALCULATE(AVERAGEX('UNION','UNION'[Preço]),'Union'[Tipo] = "Real" )

Note:In the image the total is 288.999€, but if sum the numbers you will see the sum is -119.574€

[Bruce101995]

Thank you, it worked!

[johnbasha33 · Accepted solution]

@Bruce101995 
€ Diferença =
SUMX(
SUMMARIZE(
Calendario,
Calendario[MesNome],
"Qty", [qtd],
"Diff", [Diff preço real ORCA]
),
[Qty] * [Diff]
)
If you want to go hardcore clean (sometimes better for debugging):

€ Diferença =
VAR _Table =
ADDCOLUMNS(
VALUES(Calendario[MesNome]),
"Qty", [qtd],
"Diff", [Diff preço real ORCA],
"Result", [qtd] * [Diff preço real ORCA]
)
RETURN
SUMX(_Table, [Result])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!