Create Two Measures

Thanks team and  it is really helpfull .

I have uploaded the Latest Power BI File where Mearue 2 is wokring for  seleceted week.

https://drive.google.com/file/d/10EepFFKFEmz2KIEIuJlZ--9PW5ADGICr/view?usp=sharing 

Now lets consider below output of Measure2 because Measure 3 is depedent on it.

Measure 3: Price Violation Notify consecutive weeks count

Scenario 1 : When i select Weeks =202036 the output of Measure3 is

Coffebag   0  

i will check outputs of Measure 2(0,0,0,0,0,0,0) from all available weeks(202036-202030) for Coffebag and count the latest consecutive weeks

Grape        1  

i will check outputs of Measure 2(1,0,0,1,1,1,0) from all available weeks(202036-202030) for Grape and count the latest consecutive weeks

Teabag      2  

i will check outputs of Measure 2(1,1,0,1,0,1,0) from all available weeks(202036-202030) for Teabag  and count the latest consecutive weeks

Scenario 2 : When i select Weeks =202035 the output of Measure3 is

Coffebag   0  

i will check outputs of Measure 2(0,0,0,0,0,0) from all available weeks(202035-202030) for Coffebag and count the latest consecutive weeks

Grape        0 

i will check outputs of Measure 2(0,0,1,1,1,0) from all available weeks(202035-202030) for Grape and count the latest consecutive weeks

Teabag      1

i will check outputs of Measure 2(1,0,1,0,1,0) from all available weeks(202035-202030) for Teabag  and count the latest consecutive weeks

Scenario 3 : When i select Weeks =202034 the output of Measure3 is

Coffebag   0  

i will check outputs of Measure 2(0,0,0,0,0) from all available weeks(202034-202030) for Coffebag and count the latest consecutive weeks

Grape        0 

i will check outputs of Measure 2(0,1,1,1,0) from all available weeks(202034-202030) for Grape and count the latest consecutive weeks

Teabag      0

i will check outputs of Measure 2(0,1,0,1,0) from all available weeks(202034-202030) for Teabag  and count the latest consecutive weeks

Let me know if you need more information.