Calculation

[ldbello]

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?.

[v-juanli-msft · Accepted solution]

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.

[ldbello]

Thanks a lot, could you please upload the pbix file?.

[v-juanli-msft]

Hi 

[Tahreem24]

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]

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