Forum Discussion

Digger's avatar
Digger
Post Patron
3 years ago
Solved

SUMX 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...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    Digger , Try like

     

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

     

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

amitchandak's avatar
amitchandak
Super User
3 years ago

Digger , Try like

 

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

 

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