Forum Discussion
Solved
Count unique Values in a month
I'm trying to count how many contacts a person has had in a month, the end column is what I would like it to calculate but struggling to find a measure to do this, can anyone help. T...
Kate_McCulloch , Try using
Contacts in Month =
CALCULATE(
COUNT('Table'[Contact Date]),
FILTER(
'Table',
'Table'[UNIQUE ID] = EARLIER('Table'[UNIQUE ID]) &&
MONTH('Table'[Contact Date]) = MONTH(EARLIER('Table'[Contact Date])) &&
YEAR('Table'[Contact Date]) = YEAR(EARLIER('Table'[Contact Date]))
)
)
Hi,
Here's another way. Write this measure
Measure = COUNTROWS(Data)
Write this visual calculation
Sum = CALCULATE([Measure],COLLAPSE(ROWS))