Count number of days with a negative accumulated sum

[JAB]

I have created two seperate measures which are accumulating over the calendar.

Measure 1 is:

Measure 1 :=
VAR LastVisibleDate =
MAX ( 'Calendar'[CalendarDate] )
VAR Result =
CALCULATE (
Sum(‘Table1’[Value]),
FILTER (
ALL ( 'Table2'[Code] ),
'Table2'[Code] = "311"
),
'Calendar'[CalendarDate] <= LastVisibleDate
)
RETURN
Result

Measure 2 is similar but the filter code value is different.

Measure 3 = Measure 1 + Measure 2

This is what is shown below:

	Day 2	Day 3	Day 4	Day 5	Total
Item 1	-1	0	0	0	0
Item 2	0	0	-1	1	-1
Item 3	0	2	-2	-2	-2

Now I need to count the number of days where Measure 3 is less than 0. 

My DAX knowledge is not big enough to find out how to do this. I have though of creating temporary table for the valuation but am uncertain how to do this.

[amitchandak · Accepted solution]

@JAB , Try a measure like

countx(values(Table[Item]) , if( [Measure 3] , [item], blank()))

or

countx(summarize(Table, Table[Item], Table[date],"_1" , [Measure 3]),if( [_1] , [item], blank()))

[JAB]

Hi amitchandak,

Thank you for your suggestion. I took the first suggestion and it worked just fine. Appreciate your help.

Kr

JAB