Counter in between two dates && delivery older than 5 years

[Jaesonkim]

Hello, i want to have your best solution again for the dax calculation 

i have 2 simple table as date lookup and contract table.
if i make filter with the date lookup and i choose certain year month, i want to show the contract number, which are in the between the two dates (Contract start ~ Expired date) and product delivery older than 5 years.

https://drive.google.com/file/d/1OGfUmZppS1cLcrbJOJ4M3eOXX9hiT3Tf/view?usp=share_link

[tamerj1]

Hi @Jaesonkim 
Please refer to attached sample file with the proposed solution

FilterMeasure = 
COUNTROWS ( 
    FILTER ( 
        'Table',
        DATEDIFF ( 'Table'[Product delivery], TODAY ( ), YEAR ) >= 5
            && 'Table'[Contract start] <= MAX ( 'Lookup Date'[Date] )
            && 'Table'[Expired date] >= MIN ( 'Lookup Date'[Date] )
    )
)