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.
Thanks for your solution.
However I really need a measure for this.
Measure = Calculate(COUNT(Table[TYPE]),Table[TYPE]=SALES)
SALES should be enclosed in double quotes