cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tomislav_mi
Helper II
Helper II

Top 3 Customers for each Cohort

Hey guys,

Can I get please help on this:

I am struggling to get Rank of Top 3 customers (based on sales) within each Cohort. 
I have been trying to get calculated column like in the example (highlighted orange) but always stopping somewhere.

If there is some way how to get a measure that can serve as a filter it could also be great.

Data looks like this:

CustomerReportDateLifetimeMonthCohortSalesTop3
A1/31/2020101-20202003
A2/29/2020201-2020200 
A3/31/2020301-2020300 
A4/30/2020401-2020300 
A5/31/2020501-2020300 
B1/31/2020101-20206001
B2/29/2020201-2020500 
B3/31/2020301-2020500 
B4/30/2020401-2020500 
B5/31/2020501-2020500 
B6/30/2020601-20205002
C1/31/2020101-2020350 
C2/29/2020201-2020350 
C3/31/2020301-2020350 
C4/30/2020401-2020250 
DDD5/31/2018105-2018582
DDD6/30/2018205-201868 
eee5/31/2018105-2018143
eee6/30/2018205-201814 
fff5/31/2018105-20183001
fff6/30/2018205-2018600 



Hope there is someone who can help!

Thank you all!



1 REPLY 1
Greg_Deckler
Super User
Super User

I believe I have some examples like that here:

https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors
Top Kudoed Authors