Forum Discussion
Total is wrong
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)
---------
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
3 Replies
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
But which table I need to use in the SUMX?
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])
