Sum of Negative and positive values seperately in a Measure

[Kalai20078]

Hi,

I need some help on sum the Negative and Positive values within a measure seperately.

Eg. I have the following measure 

Difference
-0.4375
0
0
0
-0.2
0
0.7875
0.055
-0.77875
0.5
0.3
0
0
-0.8
-0.125
0.1125
-0.2

Since it a measure I have problems in using the CALCULATE or SUM or any other ways to calculate the sum, I nee to calculate only the negative values and have it in a measure then sum the psoitive values and have it in a different measure. 

Result should be  -254 for negative sum and 1.7 for the positive.

Please it would be great if some one could help me.

[Anonymous]

i have a same problem but i dont understand what do you mean "Replace the Column with RowField"?@Zubair_Muhammad

[SivaMani]

@Kalai20078,

Hope! this is what you're looking for,

Posstive = CALCULATE(SUM(Table1[Difference]),Table1[Difference] > 0)

Negative = CALCULATE(SUM(Table1[Difference]),Table1[Difference] < 0)

[Kalai20078]

@SivaMani thaks for the reply

I have tried this earlier with lot other however the problem was that the difference column shown itself is a measure not the column and so it is not possible to use the measure in place of column, any other thoughts?, 

I brought the negative and positive values in a speperate measures respectively but you know the total will not be the one as expecteed in a measure put up like this,, so stuck here....

[Zubair_Muhammad]

@Kalai20078

Try this

PositiveCount =
CALCULATE ( SUM ( TableName[Difference] ), TableName[Difference] > 0 )

[Kalai20078]

@Zubair_Muhammad Thanks for your reply,

Here you mean the column 

SUM ( TableName[Difference]

However mine was a measure (The difference Iam calculating is already withing a measure), I not able to use a measure here.

[Zubair_Muhammad · Accepted solution]

@Kalai20078

Sorry I overlooked that it is a MEASURE

Which column do you use as row field

Try this. Replace the Column with RowField

PositiveCount =
SUMX (
    FILTER ( ALLSELECTED ( TableName[COLUMN] ), [Difference] > 0 ),
    [Difference]
)