Count number of dates

[Anonymous]

Hello, I would like to have a measure that counts the total number of distinct dates appearing in each month regardless if a person has a value for a date or not. Thank you

Here's the table

[Greg_Deckler · Accepted solution]

@Anonymous Maybe:

Nb of days measure =
  CALCULATE(DISTINCTCOUNT('Table'[Date]),REMOVEFILTER('Table'[Name]))

[Anonymous]

Hi @Greg_Deckler , it seems there's something I have trouble grasping with remove filters. In the example, I would like to have 9 instead of 4 and 5 (so the total number of different dates in all the months). I thought that adding 'Table'[date] to remove filters would do the trick but the result stays de same. Do you know how I need to tweak my measure? Thank you

calculate(DISTINCTCOUNT('Table'[Date]),REMOVEFILTERS('Table'[name],'Table'[date]))