Calc based on dynamic date slicer

Thanks amitchandak. I really appeciate you helping.

May be I didnt explain the logic I need for the "Final result" properly. The last file you have is doing the part highlighted in green properly. But the part highlighted in red is not what the measure5 is creating. 

For the Red part, what i mean, is if for example, date range selected in the slicer is 1/1 to 1/4, and if the test result for a product is "fail" for 1/4, then I want to see if there is a "pass" for atleast any one date between 1/1 and 1/3 (including 1/1 and 1/3). If so, call it "Okay". I am not sure how to do this part. 

If (Test_result on max date based on slicer = Pass,
     Then Final Result = Great

Else If (Test_result on max date based on slicer = Fail,
       Then
             if(Test_result = Pass for atleast 1 day in the min to max date range based on the slicer,
             Then Final result = Okay,
             Else Final result = Bad
              )

        )

)