Hi All,
I’ve been able to achieve this in Excel but am having a hard time with the context in BI yet. I’m attempting to do two things:
- Identify a customer as a Grower, Decliner or Defector based on YoY sales.
- Group these customers in even groups of 10 by their yearly rank.
I’ve been able to achieve the customer growth definition based on a measure but it’s not dynamic. I’ve attempted to make a slicer but haven’t had luck. From there, I have achieved the even grouping within the Customer Table itself but again, it’s not dynamic. Any help getting me to the finish line in the attached demo set?
eDNA Forum - Customer Decile Testing.pbix (150.8 KB)