Need help adding a date range to a measure

[RichOB]

Hi, I need to add a date range for my Canada customer count measure please. I currently have:

Measure 1: Customer_Count = Count('Sheet1'[Customer_ID])

Measure 2: Canada_Count = CALCULATE('Sheet1'[Canada], 'Sheet1'[Country] = "Canada")

The above measures gives me the total Count of 3 for Canada. What can I add to this measure to only show a date range of 01/04/2024 -30/04/2024 so a card displays 2?

Customer_ID	Country	Date
1	Canada	01/04/2024
2	Canada	02/04/2024
3	Canada	04/05/2024
4	USA	01/04/2024
5	USA	08/05/2024
6	UK	03/04/2024
7	UK	05/05/2024
8	UK	01/06/2024
9	UK	06/06/2024
10	UK	10/06/2024

Thanks

[Thennarasu_R]

Hi @RichOB 
Below mention calculation only for the  April Month Count .

Canada_Count = CALCULATE('Sheet1'[Canada], 'Sheet1'[Country] = "Canada"),AND(Date Colum>=01/04/2024,Date column<=30/04/2024)

Thanks,
Thennarasu R

If answered your questions mark accepeted a solution and give kudo !

[Muhammad_Ahmed · Accepted solution]

Hi,
you can try add one more filter inside calculate like this.
Canada_Count =
CALCULATE(
COUNT('Sheet1'[Customer_ID]),
'Sheet1'[Country] = "Canada",
'Sheet1'[Date] >= DATE(2024, 4, 1),
'Sheet1'[Date] <= DATE(2024, 4, 30)
)