Applying measure on visual filter takes a lot of time

[Dunner2020]

Hi there,

I am trying to display information into a table visual. I want to show the individual Id and their names on the table visual whose license date is expired. An Individual can renew license multiple times in the past so my logic for checking expiry license date is to pick the most recent one. Here is my measure:

Expired License = CALCULATE(DISTINCTCOUNTNOBLANK(Table[IndividualID]),FILTER(Table,Table[IndividualID] = Max(Table[IndividualID]) &&Max(Table[TableExpiryDate])<TODAY()))

When I dragged above measure into the visual filter and set its value to 1 (because I want to see information of expired license only), it takes ages to complete the processing. The table only contains just over 200k records and about 100k records might have expired license. 

Is there any way I could make it fast? Any suggestion to improve the measure?

[smpa01 · Accepted solution]

@Dunner2020  can you try this

Expired License =
CALCULATE (
    DISTINCTCOUNTNOBLANK ( Table[IndividualID] ),
    FILTER (
        VALUES ( Table[IndividualID] ),
        Table[IndividualID] = MAX ( Table[IndividualID] )
            && MAX ( Table[TableExpiryDate] ) < TODAY ()
    )
)