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.

ldbello's avatar
ldbello
Frequent Visitor
6 years ago

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