Total does not match colum

[Anonymous]

Hi everyone

It's been several days that i'm stuck with this issues and will need your help on that.

I've got a report where i tried to calculate some productivity data to get that i simply have to make an addition of the column Tot Liv and tot Ctrl-ExtPI and divide by Tot liv to get a % Ratio

Then i Multiply this Ratio to JOT_NB Tech

If you look at below spread sheet by line it does make sense, for instance on the very last line it give me 0 which is ok (0/(0+7)*1)

However when i look at the total it does not sum-up all the value it just do the same calculation but with total figures 

(238/(238+7)*10).

Which is not ok on this report ...

All the formulas are quiete simple 

Tot Ctrl Ext is => SumX(Activites,Activites[Ctrl_Ext])+SUmx(activites,Activites[Ctrl_PI])

Tot Liv is =>  SUMX(Activites,Activites[Livr-Pose])

JOT_Nbtec.Ctrl is => sumx(JOT_Date_Tec,JOT_Date_Tec[JT_tableJot])-[Tot J.Ctrl_NonProd]

Tot J.Ctrl_NonProd is => sumX(Activites,Activites[J.Ctrl_NonProductif_8hMax])

And finally JotFinal => (divide([Tot Ctrl_ExtPI],[Tot Ctrl_ExtPI]+[Tot Liv]))*[JOT_Nbtec.Ctrl]

Can anyone help on this subject i'm going crazy 

Thank you 

[amitchandak · Accepted solution]

@Anonymous ,

Try like

JotFinal => sumx(values(Activites[FibTechnicannorm]),divide([Tot Ctrl_ExtPI],[Tot Ctrl_ExtPI]+[Tot Liv])*[JOT_Nbtec.Ctrl])

[Anonymous]

@amitchandak 

Sorry to come again to you but i think you can help me on that 

One criteria that i forgot to mentionned here sometimes some days are filled with a 0 and another column in populated which is JT_notS and for some people when this column is populated the total does not match again, please see below

Formula is 

Jt_notS => sumx(Activites,Activites[H_Prod_NonService_Brut])/8

I think we have to exclude this line somehow but don't know how to do it ...

Thanks for your help 

[Anonymous]

@amitchandak 

Thanks you are a star !!!