Forum Discussion

letsdothis's avatar
letsdothis
New Member
8 years ago
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...
  • dsouzanev's avatar
    dsouzanev
    8 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Can you please clarify what you mean by daily unique sales, and how you want it broken down, by company date etc.

letsdothis's avatar
letsdothis
New Member
8 years ago

Sure, let me try:

 

I'm trying to count how many sales has been made to each company per year. But only 1 sales per day should be counted towards this number. This is due to the technical where each line item is added instead of only showing the one total line.

 

So from my data I have the following sales to Company1 in 2018:

YEAR      TYPE          COMPANY     DATE

2018       SALES       Company1     2018-01-01

2018       SALES       Company1     2018-01-01

2018       SALES       Company1     2018-01-02

 

But since the two first are from the same date, it should only count as one.

So my current result is showing 3, but I want to only show 2.

 

I hope it makes sense now, otherwise please reply.

 

Thanks again.