SUMX negative values

[Digger]

MeasureDiff = CALCULATE ( [MeasureSumSeconds] - SUM(T2[duration]))

_Measure =
VAR _Sum = SUMX(VALUE(T1[Col1]),[MeasureDiff])
RETURN
IF(_Sum<0,NegativeSums, PositivesSums)

How to get NegativeSums and  PositivesSums ?

[amitchandak · Accepted solution]

@Digger , Try like

negative sum= SUMX(filter( VALUE(T1[Col1]),[MeasureDiff]<0), [MeasureDiff])

Positive sum= SUMX(filter( VALUE(T1[Col1]),[MeasureDiff]<0), [MeasureDiff])

[v-luwang-msft]

Hi @Digger ，

Could you pls share your pbix file .Remember to remove confidential data.

Best Regards

Lucien