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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
CouncilorCox
Frequent Visitor

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 @CouncilorCox 

 

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
Twitter
LinkedIn

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors