Forum Discussion
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?.
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.
5 Replies
- 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.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
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.Thanks a lot, could you please upload the pbix file?.
