Addition of Evaluative date parameter to DAX Measure

[MSargeant]

Hi all,

I have a measure that works except when I add a date component to my visual. It appears to be evaluating for each period instead of utilising the extenal filter that was applied to the visual. There should be a third column for     2023/24 02 which designates a failure in that period for asset 34332 but as it was only one failure in that period it has been omitted - the evaluating date parameter should be less <= 84 days.

Sample data:

ASSET_NUM	ASSET_DESC	TICKET_ID	RAISED_DATE	RAISED_YEAR_PERIOD
34332	West	2985693	03/04/2023	23/24-P01
34332	West	2986260	18/04/2023	23/24-P01
34332	West	2986718	24/04/2023	23/24-P01
34332	West	2986745	27/04/2023	23/24-P01
34332	West	2986752	30/04/2023	23/24-P02
34332	West	2987520	31/05/2023	23/24-P03
34332	West	2987772	12/06/2023	23/24-P03
34332	West	2987747	12/06/2023	23/24-P03
34332	West	2988094	21/06/2023	23/24-P03

I am trying to build in a date component into the measure to see if it fixes the issue.

My original measure:

Repeat Failures = COUNTROWS(

    FILTER(

        SUMMARIZE(

        'CS_RPT_Failures','CS_RPT_Failures'[ASSETNUM],

        "TICKETID",

            COUNT('CS_RPT_Failures'[TICKETID])

        ),        

      [TICKETID]>= 3 && ISBLANK([TICKETID]) = FALSE)

       )

I have tried the following:

Repeat Failures 1 = COUNTROWS(

     FILTER( SUMMARIZE(  

        'CS_RPT_Failures', 'CS_RPT_Failures'[ASSETNUM], 'CS_RPT_Failures'[RAISED_DATE],

        "TICKETID",

        COUNT('CS_RPT_Failures'[TICKETID])

        ),

        [TICKETID] >= 3 && ISBLANK([TICKETID]) = FALSE &&

        DATEDIFF( 'CS_RPT_Failures'[RAISED_DATE], TODAY(), DAY ) <= 84)

          )

 and a couple other very similar variations but nothing has worked.