Count if the Date is less than Reporting Period slicer date selection

[spb]

Hi am trying to count 'Baseline start date' when it is <= 'Reporting period' date. 

Table
Activity ID	Baseline start date	Reporting period		Result expected
1	1/09/2031	31-May-22		Dont count
2	31/05/2022	31-May-22		Count
3	10/06/2022	31-May-22		Dont count
4	3/04/2022	31-May-22		Count
1	1/09/2031	30-Jun-22		Dont count
2	31/05/2022	30-Jun-22		Count
3	10/06/2022	30-Jun-22		Count
4	3/04/2022	30-Jun-22		Count

- when May 22 Report Period Slicer selected: Result to be 2

- when June 22 Report Period Slicer selected: Result to be 3

Also not sure if can just be a measure or whether needs a column to calculate.

thanks

[amitchandak · Accepted solution]

@spb , A new measure

countrows(filter(Table, [Baseline start date] <= [Reporting period] ) )