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
    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