Forum Discussion

saferguson's avatar
saferguson
Regular Visitor
8 years ago
Solved

Filtering grouped data

Hi,   I'm trying to figure out repeat customers (where repeat customers are defined as customers making multiple transactions on different dates (i.e. so if a customer makes 3 transactions in one d...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi saferguson,

     

    Please try below measures:

    Unique transaction dates =
CALCULATE (
    DISTINCTCOUNT ( 'Customer Transaction'[Transaction date] ),
    ALLEXCEPT ( 'Customer Transaction', 'Customer Transaction'[Customer ID] )
)

Using % repeats =
CALCULATE (
    DISTINCTCOUNT ( 'Customer Transaction'[Customer ID] ),
    FILTER ( 'Customer Transaction', [Unique transaction dates] > 1 )
)
    / DISTINCTCOUNT ( 'Customer Transaction'[Customer ID] )

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi saferguson,

 

Please try below measures:

Unique transaction dates =
CALCULATE (
    DISTINCTCOUNT ( 'Customer Transaction'[Transaction date] ),
    ALLEXCEPT ( 'Customer Transaction', 'Customer Transaction'[Customer ID] )
)

Using % repeats =
CALCULATE (
    DISTINCTCOUNT ( 'Customer Transaction'[Customer ID] ),
    FILTER ( 'Customer Transaction', [Unique transaction dates] > 1 )
)
    / DISTINCTCOUNT ( 'Customer Transaction'[Customer ID] )

 

Best regards,

Yuliana Gu

saferguson's avatar
saferguson
Regular Visitor
8 years ago

Brilliant, that works. Thank you! Could you please explain what exactly you've done just so I understand fully?