Total of positive and negatives

[Sdhn420]

Hi,

How can I show total of all negative and positive values?

I have a measure [Loss_of_Margin]

[amitchandak · Accepted solution]

@Sdhn420 , for that you need a group by context

example

+ive =

sumx(values(Table[ID]), if([Loss_of_Margin]>0,[Loss_of_Margin],blank()))

-ive

sumx(values(Table[ID]), if([Loss_of_Margin]<0,[Loss_of_Margin],blank()))

[Thennarasu_R]

Measure +IVE=
                 IF([MEASURE]>0,[Loss_of_Margin],bLANK())

MEASURE_IVE= IF([MEASURE]<0,bLANK(),[Loss_of_Margin])

[selimovd]

Hey @Sdhn420 ,

can you provide more information?

How does the measure look like? Values always need a context, positive/negative values by customer or by product or by day. In which context do you want to analyze?

Thank you and best regards

Denis

[amitchandak · Accepted solution]

@Sdhn420 , for that you need a group by context

example

+ive =

sumx(values(Table[ID]), if([Loss_of_Margin]>0,[Loss_of_Margin],blank()))

-ive

sumx(values(Table[ID]), if([Loss_of_Margin]<0,[Loss_of_Margin],blank()))

[betty_bui2602]

Hello @amitchandak , 

I found your answer and it work for my case with 1 condition. However, when i add 1 more condition, sumx total turn out wrong

I have data with 2 measue [Fcst order gap] & [%FR]

Order > Fcst =  sumx(values('MTD Attainment'[Material]), if([Fcst order Gap] > 0,[Fcst order Gap],blank()))

Order > Fcst - FR MISS = sumx(values('MTD Attainment'[Material]), if([%FR] < 1 && [Fcst order Gap] > 0,[Fcst order Gap],blank()))

By line it looks ok, but total is not right. Can you please help?

TIA 

[Sdhn420 · Accepted solution]

Thank you so much!! This worked like a charm! 😄