cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Sum of Negative and positive values seperately in a Measure

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.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Sum of Negative and positive values seperately in a Measure

@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]
)
Try my new Power BI game Cross the River

View solution in original post

5 REPLIES 5
Highlighted
Super User III
Super User III

Re: Sum of Negative and positive values seperately in a Measure

@Kalai20078

 

Try this

 

PositiveCount =
CALCULATE ( SUM ( TableName[Difference] ), TableName[Difference] > 0 )
Try my new Power BI game Cross the River
Highlighted
Solution Sage
Solution Sage

Re: Sum of Negative and positive values seperately in a Measure

@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)

Highlighted
New Member

Re: Sum of Negative and positive values seperately in a Measure

@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.

 

Highlighted
New Member

Re: Sum of Negative and positive values seperately in a Measure

@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....

Highlighted
Super User III
Super User III

Re: Sum of Negative and positive values seperately in a Measure

@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]
)
Try my new Power BI game Cross the River

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors