Measure to Isolate Negative values group by

[drivero]

Hi there!

I would like to Isolate the total value Group by Country which are negative in global:

In this case, like Italy's Total is negative, I would like to be shown as 0 and then the TOTAL should be 839578 + 25000 (because -25000 should be = 0)

I could visualize italy in total as 0, but still the total still containing the -25000

I attach a sample desktop project (https://we.tl/t-4JW0UHBxKN).

I need help, please. 

Thank you very much.

[drivero]

Hi @AlexisOlson 

I achieve what I want:

IF (
    ISINSCOPE ( DimCustomer[Country] ),
    [TotalAmount > 0],
    SUMX ( VALUES ( DimCustomer[Country] ), [TotalAmount > 0] )
)

Thank you very much for your help 🙂 !!

[AlexisOlson · Accepted solution]

One approach is to check if country is in scope (false for the total line):

IF (
    ISINSCOPE ( DimCustomer[Country] ),
    [TotalAmount],
    SUMX ( VALUES ( DimCustomer[Country] ), [TotalAmount > 0] )
)

[drivero]

@AlexisOlson 

Thanks!
Now, the total Amount is correct but I would like as well to show 0 the negative values in the visual (group by country)

Is it posible?

I would like to show Italy 0 but the total sum like the one measure you gave me 🙂