Calculate total ignoring negative

Anonymous — Wed, 27 Jul 2022 08:20:41 GMT

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 the total is 3,000 but not 2,500 but the 500 should be shown on the table. When i filter the sum for values > 0 it shows 0 on Banana's and I'd like it to show the actual amount

Apples	1,000
Oranges	2,000
Banana's	-500
Total Amount	3000

Thanks

Re: Calculate total ignoring negative

johnt75 — Wed, 27 Jul 2022 09:34:55 GMT

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 ) )

topic Re: Calculate total ignoring negative in DAX Commands and Tips

Calculate total ignoring negative

Re: Calculate total ignoring negative