Merging client data within a set time period

^{Hi LarousseG ,}

^{Please follow these steps:}

^{(1) Create a new measure}

COUNT = 
SUMX (
    'Table',
    DIVIDE (
        1,
        CALCULATE (
            COUNTROWS (
                FILTER (
                    ALL ( 'Table' ),
                    'Table'[User ID] = MAX ( 'Table'[User ID] )
                        && 'Table'[Sweep Date] = MAX ( 'Table'[Sweep Date] )
                        && ABS ( DATEDIFF ( 'Table'[Sweep Time], MAX ( 'Table'[Sweep Time] ), SECOND ) ) / 3600 < 2
                )
            )
        )
    )
)

^{(2)Final output}

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}