Forum Discussion
Solved
Count unique daily contacts
Hi all, I've tried to look at the forum for an answer, but without luck. So i'm hoping someone is able to help me. I have the following data example: YEAR TYPE COMPANY DAT...
Sorry, I replied to your post in haste. What I did was, I created a concatenated column:
Column = TableName[TYPE] & TableName[COMPANY] & TableName[DATE]
And then I created a measure using DISTINCTCOUNT:
Measure = Calculate(DISTINCTCOUNT(TableName[Column]),TableName[TYPE]="SALES")
and it worked. Please try.
Sorry, I replied to your post in haste. What I did was, I created a concatenated column:
Column = TableName[TYPE] & TableName[COMPANY] & TableName[DATE]
And then I created a measure using DISTINCTCOUNT:
Measure = Calculate(DISTINCTCOUNT(TableName[Column]),TableName[TYPE]="SALES")
and it worked. Please try.
Thank you all for your replies.
I got the solution ow, thanks!