Count number of rows within date range. (Example file attached)

[StuartSmith]

I'm trying to count the number of public holidays for a country within a table visual, but cant seem to get it working, its just counting all the public holidays.  

I have attached an example file.  Public Holidays within Period. 

Thanks in advance.

[MBernalBI · Accepted solution]

I have made a DAX measure and I recommend it to do this type of calculation.

Public Holidays = 
var _minDate = SELECTEDVALUE('Time to Fill'[Position Open Date])
var _maxDate = SELECTEDVALUE('Time to Fill'[Vacant Position Filled With Today If Still Vacant])

return

CALCULATE(COUNTROWS('Public Holidays'),DATESBETWEEN('Public Holidays'[Holiday Date],_minDate, _maxDate))

I hope that this can help you.

[StuartSmith]

That worked great.  I was trying "SelectedValue", but wasnt using "DatesBetween" 🙂. Anyway, thanks 

[StuartSmith]

Is anyone able to assist or advise.