Help for Measure with Custom Rule DAX Formula

Hi Anonymous ,

You could use RANKX() to create an index firstly.

rank = 
RANKX('Table','Table'[Date],,ASC,Dense)

Then create a measure and the output is 1 or 0.

measure =
VAR a =
    LOOKUPVALUE (
        'Table'[User],
        'Table'[rank], SELECTEDVALUE ( 'Table'[rank] ) + 1
    )
VAR b =
    LOOKUPVALUE (
        'Table'[TypeOfVisit],
        'Table'[rank], SELECTEDVALUE ( 'Table'[rank] ) + 1
    )
RETURN
    IF ( a = "A" && b = "T2", 0, 1 )

 Now you could use filter to show result whose measure is 1.