Count dates after given date

[MiroslawW]

Hello,

I have got problem to find solution of counting dates after given date. 

Table1

Name	Option 1	Option 2	Option 3
Name 1	17/03/2023
Name 2	16/03/2023
Name 3
Name 4	13/03/2023
Name 5		18/02/2020
Name 6
Name 7			17/03/2023
Name 8			16/03/2023
Name 9	18/03/2020	13/03/2023
Name 10
Name 11
Name 12
Name 13			03/12/2021
Name 14	01/01/2020
Name 15
Name 16
Name 17			16/03/2022
Name 18
Name 19
Name 20		03/12/2021
Name 21	03/12/2021
Name 22
Name 23
Name 24		16/03/2022
Name 25	16/03/2022
Name 26
Name 27
Name 28

I tried to use measure to count: 

Measure 1= CALCULATE(COUNT(Table1[Option 1]), Table1[Option 1]<> BLANK(), Table1[Option 1]>01/01/2023)

That should give me number Measure 1 = 3 but it counts whole column Measure 1 = 7 

Why while calculating this measure it is not dropping dates

I tried to look diffrent solution: with countrow, filter but none of them worked. 

Any ideas.

Regards,

MW

[HotChilli · Accepted solution]

The date is not being recognised.  Use DATE(...) instead of just writing 01/01/2023.  The intellisense will help you

[HotChilli · Accepted solution]

The date is not being recognised.  Use DATE(...) instead of just writing 01/01/2023.  The intellisense will help you

[MiroslawW]

Hi,

I tired to make this more automated added this line:

Measure 1= CALCULATE(COUNT(Table1[Option 1]), Table1[Option 1]<> BLANK(), Table1[Option 1]>TODAY())

and this time it shows me some weird numbers.

[MiroslawW · Accepted solution]

Thanks that worked.