SUM specific values in Column

[hjmm]

I have an important column with positive, zero and negative numbers. I need to SUM the negative and postive values separately. New to Powerbi hopefully simple solution.

[jdbuchanan71 · Accepted solution]

@hjmm 

Try these.

Positive = CALCULATE ( SUM ( 'Table'[Amount] ) , 'Table'[Amount] > 0 )

Negative = CALCULATE ( SUM ( 'Table'[Amount] ) , 'Table'[Amount] < 0 )

[SpartaBI · Accepted solution]

@hjmm 

SUM_Positive = 

CALCULATE(SUM('Table'[Column]), .Table'[Column] > 0)

Same for negative, just replace > with <.

Put your table and column names instead the generic names I used

[hjmm]

So simple. Thanks

[jdbuchanan71 · Accepted solution]

@hjmm 

Try these.

Positive = CALCULATE ( SUM ( 'Table'[Amount] ) , 'Table'[Amount] > 0 )

Negative = CALCULATE ( SUM ( 'Table'[Amount] ) , 'Table'[Amount] < 0 )

[hjmm]

Thank you