Calc based on dynamic date slicer

Hi,   I have data like the below table.  Date   Category   Product   Test_result 1/1/2021   A   xyz   Pass 1/1/2021   A   pqr   Fail 1/1/2021   B   abc   Fail ...