cancel
Showing results for
Did you mean:
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

## 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
5 REPLIES 5
Highlighted
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

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

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

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

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

## 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

Announcements

#### August 2020 Community Challenge: Can You Solve These?

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

#### Community Blog

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

#### 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

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

Top Solution Authors
Top Kudoed Authors