Forum Discussion
Automatic sum issues
Hello, I have a problem with the automatic sum in the table below (even in graphique) its sums the two last lines and after that it substract the first one only for the second columns ...
HI Anonymous,
It seems like a common measure total issue, does the sorties formula work with filters or special conditions? If that is the case, you can take a look at Greg's blog to know how to fix this:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
HI Anonymous,
It seems like a common measure total issue, does the sorties formula work with filters or special conditions? If that is the case, you can take a look at Greg's blog to know how to fix this:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
I found the problème guys thank you . the formula was
Sorties =
abs(CALCULATE(
(sum(TABLE_DE_FAIT_MVT[Valeur MVT signée])),
DIM_TYPE_MVT[SENS_COMPTABLE] in {"S"})
)
the pissue was with the abs function that first sum all vlaues and after that dot the abs.
the solution i creat an agregation first of the abs vlaues of each rows.
Entrées/Sorties = SUMMARIZE(TABLE_DE_FAIT_MVT,TABLE_DE_FAIT_MVT[CODE_MAGASIN],TABLE_DE_FAIT_MVT[Activite],TABLE_DE_FAIT_MVT[Centre],TABLE_DE_FAIT_MVT[Etablissement],TABLE_DE_FAIT_MVT[DEPARTEMENT],TABLE_DE_FAIT_MVT[PERIODE_COMPTABLE],
"E",CALCULATE(
(sum(TABLE_DE_FAIT_MVT[Valeur MVT signée])),
DIM_TYPE_MVT[SENS_COMPTABLE] in {"E"}),
"S", CALCULATE(
(sum(TABLE_DE_FAIT_MVT[Valeur MVT signée])),
DIM_TYPE_MVT[SENS_COMPTABLE] in {"S"}))