Forum Discussion
Count unique daily contacts
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.
Advocate VYou should be able to do this without any DAX formulas at all.
- Take a table visual
- Use the date field as the values and set the option to show as Count (Distinct) and make sure you have Date selected rather than Date Heirarchy
- Put the Type column into the visual filters and filter on Sales only.
- Put Company into the rows section
Thanks for your solution.
However I really need a measure for this.
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!
Measure = Calculate(COUNT(Table[TYPE]),Table[TYPE]="SALES")
Measure = Calculate(COUNT(Table[TYPE]),Table[TYPE]=SALES)
SALES should be enclosed in double quotes
For uniqueness you could try DISTINCTCOUNT instead of COUNT