Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculate total ignoring negative

Hi everyone, I'm trying to calculate total amount ignoring -ve values in the sum but displaying them on the table. For example I want to calculate total for Apples, Oranges and Banana's whereby th...
  • johnt75's avatar
    johnt75
    4 years ago

    You could return different values based on whether an individual item was in scope or not, e.g.

    Amount = IF( ISINSCOPE( 'Table'[Fruit] ), SUM('Table'[Value]), 
CALCULATE( SUM('Table'[Value]), 'Table'[Value] > 0 )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You could return different values based on whether an individual item was in scope or not, e.g.

Amount = IF( ISINSCOPE( 'Table'[Fruit] ), SUM('Table'[Value]), 
CALCULATE( SUM('Table'[Value]), 'Table'[Value] > 0 )
)