cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

## How to count only one value from rows with same values

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?

Br,

Silvia

1 ACCEPTED SOLUTION
Super User

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:

Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards

3 REPLIES 3
Regular Visitor

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?

Regards

Regular Visitor

Thank you 🙂

Super User

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:

Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards