Selectedvalue and calculated columns

[Birthe]

I have been struggling all day now. Can someone please help me?

To simplify, I have a table (+1000 records) with contracts, all having a start and an end date:

Contractnr	ContractFrom (date)	ContractUntil (date)
1	01/01/2010	05/06/2023
2	05/04/2023	04/03/2028

I also have a date table 'Date'[date] , linked to other significant information.

As a result, I want to select one of the dates in my date table, and show how many contracts are valid for that given date.

As a first step, I was trying the following but it does not work

I wanted an extra column in the contracts table above with formula: 

DateBetween = IF(

    AND (

        'Contracts'[ContractFrom] <= SELECTEDVALUE('Date'[Date]),

        'Contracts'[ContractUntil] >= SELECTEDVALUE('Date'[Date])

    ),

    "Yes",

    "No")

This does not give the expected result. Can somebody help me? 

Thank you very much! Birthe

[Birthe]

Thank you so much ERD! 

[ERD · Accepted solution]

@Birthe ,

You can try this measure:

DateBetween =
VAR _from =
    SELECTEDVALUE ( 'Table'[ContractFrom] )
VAR _to =
    SELECTEDVALUE ( 'Table'[ContractUntil)] )
VAR _date =
    SELECTEDVALUE ( 'Date'[Date] )
RETURN
    IF ( _date >= _from && _date <= _to, 1, 0 )