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.

bizbi's avatar
bizbi
Advocate I
8 years ago

Hello,

 

Are you looking for the count considering unique combination of Company Name, Date and Type? Another way to say the same: Is this what you are looking for?

 

YEAR     TYPE       COMPANY    DATECOUNT
     
2018      SALES       Company1    01-01-20182
     
2018      OFFER     Company1    01-01-20181
     
2018      SALES      Company1    02-01-20181
     
2018      SALES      Company2    02-01-20181
     
2018      OFFER     Company2    03-01-20181
     
2017      SALES      Company1    01-01-20171
     
2017      SALES      Company2    01-01-20171
  • letsdothis's avatar
    letsdothis
    New Member
    8 years ago

    Thank you for your reply.

     

    Sort of, I'm looking to remove duplicates for the combination of Company Name, Date and Type.

    In your table the sum of all SALES in 2018 is 4, but I only want to show 3 (as there is a duplicate on date 2018-01-01).

     

    Thanks again.