Difficult Sum Measure

HI PAschieri ,
Understood now, please try the bellow measure:

Calculated Hours = 
VAR HasActivitiesCode100 = 
    CALCULATE(
        SUM('Activities'[Activities]),
        'Activities'[Code] = 100
    ) > 0

RETURN
IF(
    HasActivitiesCode100, 
    CALCULATE(SUM('Hours'[Hours]), ALLEXCEPT('Company', 'Company'[Name])),
    CALCULATE(SUM('Hours'[Hours]), ALLEXCEPT('Company', 'Company'[Name]))
)

Hi PAschieri ,

Thanks for all the replies!
And PAschieri , I create sample data myself:

You can use this DAX to create a measure:

TotalHoursWithCondition = 
VAR _table =
    CALCULATETABLE (
        VALUES ( Data[Company] ),
        FILTER ( ALL ( Data ), 'Data'[Code] = 100 )
    )
RETURN
    CALCULATE ( SUM ( 'Data'[Hours] ), ALL ( Data ), 'Data'[Company] IN _table )

And the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.