How to get the total of negative values of categories?

[MuradMusleh]

Hi everyone, 
I have more than 4 measures to calculate the loss time hours. I need to show the total of category only if the total of segment is negative. The total of segment is calculated based on products regardless of their value if it is positive or negative. All what I care about is if the total of segment is negative so it should be added to other subtotals of the category. 

In the attached image, you can find the grand total is 52.57 but the correct one that is needed is 8.63 only because the other subtotal of segment 2 and 3 are positive.

[MuradMusleh · Accepted solution]

Thanks everyone
After a while of work, I found the solution

EEE =

VAR Neg_Value =  CALCULATE([Loss Time (HR)], FILTER( VALUES ( 'TableName' [Segment] ) , [Loss Time (HR)] < 0 ) )

RETURN

Neg_Value

The grand total sum and shows only the sum of negative subgrand total only.

[MuradMusleh]

Thanks for your reply. 
All what I need is to sum the negative subtotals only and omit the positive values.

[vapid128]

If your Loss time is a meausre

Sumx(

    values([Plants)],

    if(

        [measuer]<0,

        calculate([measuer]),

        0

    )

)

[vapid128]

I don think you need add all negative numbers.

I would do:

Sumx(values([Plants)],calculate(max([measuer],0)))

that will show no negative numbers.