Calculated Column for counting days with gaps

[pasc43]

I am trying to make a calculated column that returns the count of days in which Oil was > 0 for each Well ID. Here is some sample data and the Days On column is what I want the calculated column to show. Any help is appreciated. Thanks! 

Well ID	On Production Date	Production Date	Oil		Days On
0434	1-Mar-17	24-Feb-17	0		0
0434	1-Mar-17	25-Feb-17	0		0
0434	1-Mar-17	26-Feb-17	0		0
0434	1-Mar-17	27-Feb-17	0		0
0434	1-Mar-17	28-Feb-17	0		0
0434	1-Mar-17	1-Mar-17	63		1
0434	1-Mar-17	2-Mar-17	35		2
0434	1-Mar-17	3-Mar-17	0		0
0434	1-Mar-17	4-Mar-17	0		0
0434	1-Mar-17	5-Mar-17	8		3
0434	1-Mar-17	6-Mar-17	14		4
0434	1-Mar-17	7-Mar-17	47		5
0434	1-Mar-17	8-Mar-17	47		6
0434	1-Mar-17	9-Mar-17	54		7
0434	1-Mar-17	10-Mar-17	49		8
0434	1-Mar-17	11-Mar-17	62		9
0434	1-Mar-17	12-Mar-17	31		10
0434	1-Mar-17	13-Mar-17	34		11
0434	1-Mar-17	14-Mar-17	60		12
0434	1-Mar-17	15-Mar-17	49		13
0434	1-Mar-17	16-Mar-17	0		0
0434	1-Mar-17	17-Mar-17	0		0
0434	1-Mar-17	18-Mar-17	50		14
0434	1-Mar-17	19-Mar-17	32		15
0887	8-Apr-17	6-Apr-17	0		0
0887	8-Apr-17	7-Apr-17	0		0
0887	8-Apr-17	8-Apr-17	0		0
0887	8-Apr-17	9-Apr-17	80		1
0887	8-Apr-17	10-Apr-17	78		2
0887	8-Apr-17	11-Apr-17	65		3
0887	8-Apr-17	12-Apr-17	0		0
0887	8-Apr-17	13-Apr-17	45		4
0887	8-Apr-17	14-Apr-17	35		5
0887	8-Apr-17	15-Apr-17	55		6
0887	8-Apr-17	16-Apr-17	85		7
0887	8-Apr-17	17-Apr-17	70		8
0887	8-Apr-17	18-Apr-17	0		0
0887	8-Apr-17	19-Apr-17	0		0
0887	8-Apr-17	20-Apr-17	0		0
0887	8-Apr-17	21-Apr-17	0		0
0887	8-Apr-17	22-Apr-17	0		0
0887	8-Apr-17	23-Apr-17	0		0
0887	8-Apr-17	24-Apr-17	31		9
0887	8-Apr-17	25-Apr-17	34		10

[pasc43]

Thank you so much!

[ribisht17 · Accepted solution]

@pasc43 

Column 4 = if(Oil[Production]=0,0, CALCULATE(COUNT(Oil[Date]),

FILTER(ALLEXCEPT(Oil,Oil[ID]),Oil[Date] <= EARLIER(Oil[Date])),Oil[Production]>0)

)

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series