Creating a measure with only negative monthly sums

[Anonymous]

Hello,

I am attempting to single out ONLY the negative monthly values.  These values are a sum of daily values using this measure:

TotalMTD = TOTALMTD(SUM('Table1'[Value]),'Table1'[DAY])

This returns

May  1000

June 1500

July  500

August -400

September -500

October -300

What can I write in order to isolate JUST the negative values from that TOTALMTD measure?

Thank you very much!

[v-piga-msft · Accepted solution]

Hi @Anonymous.

If I understand your requirement correctly that you only want to show the negative monthly sums. 

If it is, you could create another measure with the formula below and drag it as the visual level filter like below.

IF([Mtd]>0,0,1)

In addition, you also could modify your formula like below.

TotalMTD =
IF (
    TOTALMTD ( SUM ( 'Table1'[Value] ), 'Table1'[DAY] ) < 0,
    TOTALMTD ( SUM ( 'Table1'[Value] ), 'Table1'[DAY] ),
    BLANK ()
)

If you still need help, please feel free to ask.

Best Regards,

Cherry