Forum Discussion

Peter_2020's avatar
Peter_2020
Helper III
3 years ago
Solved

SUM with specific filter 2

Hi all,  I would like to ask you for help with following situation: I have this table with lot of different PO´s. The issue I will explain you on one PO like an example: As you can see each P...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    OK, try

    Sum hours =
CALCULATE (
    SUM ( 'Table'[Hours] ),
    ALLEXCEPT ( 'Table', 'Table'[PO], 'Table'[Operation] )
)
johnt75's avatar
johnt75
Super User
3 years ago

Try

Sum hours =
VAR SummaryTable =
    SUMMARIZE ( 'Table', 'Table'[PO], 'Table'[Operation], 'Table'[RC] )
VAR Result =
    CALCULATE ( SUM ( 'Table'[Hours] ), SummaryTable )
RETURN
    Result
Peter_2020's avatar
Peter_2020
Helper III
3 years ago

Hi johnt75 , 

thank you for your reply. It calculate the sum of the hours but it is split by the RC number what is wrong:

What I need is to get the sum of all hours for specific PO  and Operation to both lines with RC number. 

P.