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
do you have any idea please to fix the issue
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
5 Replies
Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.amitchandakth probleme is with the first line if don't select it ( have only the the two lines ST074, ST075) the total is correct but if filter by selecting the ST073, ST074 and ST075) the total is flase of the last column
Centre Entrées Sorties
ST073 128054,2 83364,26 ST074 101311,34 100395,16 ST075 56262,19 77785,65
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"}))
Hi Anonymous
Would you copy the measure code for Entrées & Sorties?
