Forum Discussion

ldbello's avatar
ldbello
Frequent Visitor
6 years ago
Solved

Calculation

Dear all,   I want to create a new meassure using only possitive values, the result expected must be 563.05, not 383.10. Could you help me please?.
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi ldbello 

    Measure = SUM('Table'[column])

Measure 2 = IF(HASONEVALUE('Table'[index]),[Measure],SUMX(FILTER('Table',[Measure]>0),[Measure]))

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Tahreem24's avatar
Tahreem24
Super User
6 years ago
You can try the below measure:
positive Sum= Calculate(Sum(Table[NumericValue]), NumericValue>0)

Don't forget to give thumbs up 👍 and accept this as a solution if it helps you.
ldbello's avatar
ldbello
Frequent Visitor
6 years ago

Thanks a lot, it doesn´t work because I don´t have any table, I´m working only with meassure, I need that the formula don´t include the negative values, the response expected should be 563