Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

1 REPLY 1
OwenAuger
Super User
Super User

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


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
LinkedIn

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.