topic How to count only one value from rows with same values in DAX Commands and Tips

How to count only one value from rows with same values

SilviaF — Wed, 17 Apr 2024 13:59:11 GMT

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

Re: How to count only one value from rows with same values

qqqqqwwwweeerrr — Sat, 22 Jun 2024 05:55:16 GMT

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

Re: How to count only one value from rows with same values

SilviaF — Thu, 18 Apr 2024 04:57:27 GMT

Thank you 🙂

Re: How to count only one value from rows with same values

SilviaF — Thu, 18 Apr 2024 11:22:13 GMT

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