Automatic sum issues

[Anonymous]

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 

[ALLUREAN]

Hi @Anonymous 

Would you copy the measure code for Entrées & Sorties?

[Anonymous · Accepted solution]

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

[Anonymous]

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"}))

[amitchandak]

@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.

[Anonymous]

@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