distinct count with filter

[Anonymous]

Good Morning,

I need some help please with a distinct count with a filter.

The count is for customer, i need to filter on two dates so it is only counting where the first date is greater than the second date.

For example in the below table i would get a result of 3:

Customer	Date 1	Date 2
1	26/01/2020	28/02/2022
1	28/12/2021	25/11/2021
2	31/02/2022	31/01/2022
3	01/06/2021	31/05/2021
3	05/08/2020	07/04/2022

[Anonymous]

Hi the tables are joined by the customer number

[lukiz84]

How? Can you show a picture?

How does Table 1 know, which Date 2 belongs to which Date 1?

[Anonymous]

Thank you, i forgot to say that the two dates are from two different tables. 

[lukiz84]

And how are those tables connected?!

[lukiz84]

Hi,

CustomerCount =
   CALCULATE(
      DISTINCTCOUNT(table[Customer]),
      FILTER(
         table,
         table[Date 1] > table[Date 2]
      )
   )