Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 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
Solved! Go to Solution.
@Anonymous ,
Try like
JotFinal => sumx(values(Activites[FibTechnicannorm]),divide([Tot Ctrl_ExtPI],[Tot Ctrl_ExtPI]+[Tot Liv])*[JOT_Nbtec.Ctrl])
@Anonymous ,
Try like
JotFinal => sumx(values(Activites[FibTechnicannorm]),divide([Tot Ctrl_ExtPI],[Tot Ctrl_ExtPI]+[Tot Liv])*[JOT_Nbtec.Ctrl])
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
I think we have to exclude this line somehow but don't know how to do it ...
Thanks for your help
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |