Distinct Count Based On Measure

[Anonymous]

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

[OwenAuger]

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