Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
SilviaF
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.

SilviaF_0-1713360586691.png

 

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

 

 

1 ACCEPTED SOLUTION
qqqqqwwwweeerrr
Super User
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:
qqqqqwwwweeerrr_0-1713365820225.png

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

Regards

View solution in original post

3 REPLIES 3
SilviaF
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:

SilviaF_0-1713439238002.png

I think, that it needs another measure, am I right?

 

Thank you in advance!

 

Regards

SilviaF
Regular Visitor

Thank you 🙂

qqqqqwwwweeerrr
Super User
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:
qqqqqwwwweeerrr_0-1713365820225.png

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

Regards

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors