Forum Discussion

SilviaF's avatar
SilviaF
Regular Visitor
2 years ago
Solved

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...
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago

    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

SilviaF's avatar
SilviaF
Regular Visitor
2 years ago

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