Total is wrong

[gcz]

The total is wrong, I really dont know why.

Print: imgur.com/a/5mbub

---------

Estoque Disponível VAR e IF =

VAR x = SUMX(SUMMARIZE(ESTOQUE;ESTOQUE[PRODUTO];ESTOQUE[SALDO]);ESTOQUE[SALDO])      // SALDO

VAR y = CALCULATE([Total Pendência];ALL(CALENDARIO[Data]))                                                             // PENDENCIA

VAR z = ALLSELECTED(CALENDARIO[Data])

RETURN CALCULATE(IF(x = 0;BLANK();IF(x - y < 0;BLANK();x - y))
;z)

---------

[MFelix · Accepted solution]

Hi @gcz,

You want the total to be the sum of the several lines correct?

So you need to do the SUMX of the Calculate function you have on your Return, like you have the formula setup you are making the calculations for the total rows and then using the IF, because the measure is based on context.

Regards,

MFelix

[gcz]

I created this code: 

Estoque Disponível VAR e IF by Felipe =

VAR x = SUMX(SUMMARIZE(ESTOQUE;ESTOQUE[PRODUTO];ESTOQUE[SALDO]);ESTOQUE[SALDO]) // SALDO
VAR y = CALCULATE([Total Pendência];ALL(CALENDARIO[Data])) // PENDENCIA
VAR z = ALLSELECTED(CALENDARIO[Data])

RETURN SUMX(VALUES(PRODUTOS[PRO_CODPRO]);CALCULATE(IF(x = 0;BLANK();IF(x - y < 0;BLANK();x - y));z))

______________________________________________________________________________________________________________________

Still the same error, total is different.

Print: imgur.com/a/pj5HY

And I created a code to give me the correct total: 

TOTAL Estoque Disponível VAR e IF = SUMX(VALUES(PRODUTOS[PRO_CODPRO]);ESTOQUE[Estoque Disponível VAR e IF])

[gcz]

But which table I need to use in the SUMX?