DAX Formula Rolling Sum when Flag is 1, however, Sum should set to 0 if continuity fails.

[aadusumilli]

Date	Flag	Needed Column	Comments
Wednesday, April 1, 2020	0	0
Thursday, April 2, 2020	1	1
Friday, April 3, 2020	1	2	increment by 1 when flg=1
Saturday, April 4, 2020	1	3
Sunday, April 5, 2020	1	4
Monday, April 6, 2020	1	5
Wednesday, April 8, 2020	0	0
Thursday, April 9, 2020	0	0
Friday, April 10, 2020	1	1	New Occurance
Saturday, April 11, 2020	0	0
Sunday, April 12, 2020	1	1	New Occurance
Monday, April 13, 2020	0	0
Tuesday, April 14, 2020	1	1	New Occurance
Wednesday, April 15, 2020	0	0
Thursday, April 16, 2020	1	1	New Occurance

I have tried this but I would want to reset the sum to 1 on 04/10, 04/12 and so on,

Part of it is achieved with formula for Sum Field Below; 

Sum = IF(Table1[Flag]=0,0,CALCULATE(SUM(Table1[Flag]),FILTER(Table1,Table1[Date] <= EARLIER(table1[Date]))))

Date	Flag	Sum
Wednesday, April 1, 2020	0	0
Thursday, April 2, 2020	1	1
Friday, April 3, 2020	1	2
Saturday, April 4, 2020	1	3
Sunday, April 5, 2020	1	4
Monday, April 6, 2020	1	5
Wednesday, April 8, 2020	0	0
Thursday, April 9, 2020	0	0
Friday, April 10, 2020	1	6
Saturday, April 11, 2020	0	0
Sunday, April 12, 2020	1	7
Monday, April 13, 2020	0	0
Tuesday, April 14, 2020	1	8
Wednesday, April 15, 2020	0	0
Thursday, April 16, 2020	1	9

[Greg_Deckler · Accepted solution]

Seems like Cthulhu. https://community.powerbi.com/t5/Quick-Measures-Gallery/Cthulhu/td-p/509739

[aadusumilli]

OMG!! this is great.

Thanks for the quick response, Greg. it really helped.

However, i did change a litttle on Return Part; if this helps anyone

RETURN IF(table1[Flag] = 1,IF(ISBLANK(__max),1,IF(__max=[Index]-1,COUNTX(__tmpTable3,[Index])+1,1)),0)