Max Function

Create a Rank and filter Rank 1.

Refer

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970


https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Sorry, Anonymous 

my bad. try Rank by SUM

Rank = rankx(filter('Table1';Table1[YearQuarter]=earlier('Table1'[YearQuarter]));sum(Table1[lead sold]))

 also, you could share your pbix-file on any cloud service like https://uploadfiles.io/

do not hesitate to give a kudo to useful posts and mark solutions as solution

Hi Anonymous ,

You can try the following methods:
1. Create a calculated column as follows:

Quarter = "Q" & INT ( FORMAT ( [Date], "q") )

2. Create the following two measures:

sum_LS = sum('Table'[Leads_Sold])

Rank = RANKX(ALL('Table'[AREA]),[sum_LS])

3. Filter Rank:

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ERi36XK2deZJqSrulxj0YjgBr_6f9YvEk0s6U8GYlOJvtg?e=lkjgaE

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.