Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have this table:
It is showing how long it takes to provide some work - Standard time is for combination order and operation always the same but operation time is changing.
What I need to get is that on order 115847 an operation 50 they fulfill the standard time for 1,11 (20/(8+5+5)), for order 115847 and operation 60 it was only 0,51 (30/58).
It means Standard time / Sum of operation time.
What I cannot get is how to count only one value in standard time and not sum of all rows. It is possible to create some measure?
Thank you in advance!
Br,
Silvia
Solved! Go to Solution.
Hi @SilviaF
You can achieve by creating a new measre as follows:
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem
Regards
HI, @qqqqqwwwweeerrr ,
thank you again, but I found out that I have problem when I want to make sum of all rows. Because it takes only maximum of standard time and I need to get SUM of all MAXIMUM to each order+operation.
Something like that:
I think, that it needs another measure, am I right?
Thank you in advance!
Regards
Thank you 🙂
Hi @SilviaF
You can achieve by creating a new measre as follows:
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem
Regards