Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Distinct Count Based On Measure

I have a measure that calculates the number of days since a customer's last purchase. Now I need three measures to count the customers that fall into the following segements Active (0-30 days), Lapsed (30 - 60 days), Lost (60 days plus). Is there a DAX pattern that can do this or do I need to come at it from a different angle?

 

Thanks

Coxy

DAX
Distinct Counts

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Super User
    6 years ago

    Hi Anonymous 

     

    You should be able to do this using the Dynamic Sementation pattern.

     

    You just have to set up a segment table, then write an appropriate segmentation measure following the pattern on the above page.

     

    Please post back if you need help with the specifics for your data model.

     

    Regards,

    Owen