Counting Repeat Customers Measure to use in Conditional Formatting

[a68tbird]

Hello all -

  Having some trouble wrapping my head around this.  I would like to count the number of repeat customers in my Orders table. The customer email is the unique value to count.  I want to be able to use this calculation to create a table such as the one represented below:

The conditional formatting I should be able to figure out, but I'm not sure how to create the DAX for this. It needs to be able to identify repeat emails, and the number of times it repeats.  Filter context for the YEAR should occur in the table - that is, the DAX shouldn't need to consider the year - just the entire Orders table. This way, if I want to look at all years, or drill down to quarters and months, it should still return the relevant results. Will it require five different measures - one for each bin of "# of Orders"? 

Any suggestions?

Thanks!

[amitchandak]

@a68tbird , First create a measure that will give new, lost or repeat like

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q

And then you can use count based on segmentation. And you can use the measure to do conditional formatting

Learn Power BI Advance - PowerBI Abstract Thesis:
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...