How to count only one value from rows with same values

[SilviaF]

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

[SilviaF]

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

[SilviaF]

Thank you 🙂

[qqqqqwwwweeerrr · Accepted solution]

Hi @SilviaF 

You can achieve by creating a new measre as follows:

Measure = MAX('Table'[ Standard time]) / SUM('Table'[Operation time])

below is my output:

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards