Forum Discussion

Digger's avatar
Digger
Icon for Post Patron rankPost 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])

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Digger ，

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

 

 

 

Best Regards

Lucien