SUM of values in specific rows

[Peter_2020]

Hi all, 

I would like to ask you for help with following issue:

I have the table "PRODUCTION" with data about orders, operations and production hours:

As you can see I have 4 orders (1060370272, 1060370274, 1060371650, 1060371662) with different operations and different reported hours. What I want to achieve is the chart with SUM of hours but only for each order which contain operation "0200". In that case the result looks like this:

The question is how to define formula for calculation of that kind of measure.

Thank you for help!

P.

[Sumanth_23 · Accepted solution]

hi @Peter_2020 - You can implement the same using the below approach. 

1. I have created a measure for Total Hours: Tot Hours = SUM(PRODUCTION[Hours])

2. Added a calculated column to identify Orders which have operation type "0200" : 

Operation_check = IF ( PRODUCTION[Operation] = "0200" , 1, 0)

3. Plotted Orders vs. Tot Hours and then applied a visual level filter to only show orders that had a "Operation_check" = 1

Please mark the post as a solution and provide a 👍 if my solution helped with solving your issue. Thanks!

[Peter_2020]

@Sumanth_23 Thank you very much for your help! It solved my problem.

[Sumanth_23]

hi @Peter_2020 - Happy to help! 🙂

Do kudo the solution so it highlights to other folks with a similar request as well. Thanks!  

[ryan_mayu]

@Peter_2020 

Maybe you can try

CALCULATE(SUM(Hours）,FILTER(TABLE, OPERATION="0200")

[Peter_2020]

@ryan

sorry Ryan, but it doesn´t work. I need to define somehow that I need calculate sum of all rows for column "hours" just for orders which contain operation "0200"...

[ryan_mayu]

@Peter_2020 

please provide some sample data and the expected output.