Forum Discussion

Peter_2020's avatar
Peter_2020
Icon for Helper III rankHelper 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] )
)