Forum Discussion
Digger
Post Patron
Post PatronSUMX negative values
MeasureDiff = CALCULATE ( [MeasureSumSeconds] - SUM(T2[duration])) _Measure = VAR _Sum = SUMX(VALUE(T1[Col1]),[MeasureDiff]) RETURN IF(_Sum<0,NegativeSums, PositivesSums) How to get Nega...
Digger , Try like
negative sum= SUMX(filter( VALUE(T1[Col1]),[MeasureDiff]<0), [MeasureDiff])
Positive sum= SUMX(filter( VALUE(T1[Col1]),[MeasureDiff]<0), [MeasureDiff])
amitchandak
Super User
Super UserDigger , Try like
negative sum= SUMX(filter( VALUE(T1[Col1]),[MeasureDiff]<0), [MeasureDiff])
Positive sum= SUMX(filter( VALUE(T1[Col1]),[MeasureDiff]<0), [MeasureDiff])