Forum Discussion

adamlang's avatar
adamlang
Icon for Helper III rankHelper III
3 years ago
Solved

Counting Unique Activities Based on Customer Number and Date Time

Hi all,

 

I need to de-duplicate some data refering to meetings in a Dax Measure. A duplicate meeting is a meeting where the same customer has a meeting at the same date time, this would be one meeting. I need to count unique meetings. As in the below data there would be 7 Unique Meetings.

 

 

 

I hope that's clear, happy to answer any questions.

 

Thanks,

 

Adam

  • nirali_arora's avatar
    nirali_arora
    3 years ago
    The following measure will count unique meetings
    UniqueMeetingsCount = COUNTROWS(
        SUMMARIZE(
            'Table',
            'Table'[Customer Number],
            'Table'[Date Time]
        )
    )

3 Replies

  • nirali_arora's avatar
    nirali_arora
    Icon for Resolver II rankResolver II
    3 years ago
    The following measure will count unique meetings
    UniqueMeetingsCount = COUNTROWS(
        SUMMARIZE(
            'Table',
            'Table'[Customer Number],
            'Table'[Date Time]
        )
    )
    • adamlang's avatar
      adamlang
      Icon for Helper III rankHelper III
      3 years ago

      Thanks nirali_arora that's a quick response.

       

      That measure worked.

       

      How would I add a additional filter to include an additional field -  [Meeting status] that are "Attended"? Would I wrap it all in a CALULATE function?

       

      Thanks,

       

      Adam

  • nirali_arora's avatar
    nirali_arora
    Icon for Resolver II rankResolver II
    3 years ago

    Instead of taking complete table in summarize you can use this filter.

    FILTER(Meetings, Meetings[Meeting Status] = "Attended")

    Please accept the solution if the measure works.

    Thank you : )