Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

distinct count with filter

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 s...
Need Help
lukiz84's avatar
lukiz84
Memorable Member
3 years ago

Hi,

 

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