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 NegativeSums and  PositivesSums ?

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])

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    3 years ago

    Hi Digger ，

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

     

     

     

    Best Regards

    Lucien

  • 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])