RANKX within multiple groups

[_NewToPowerBI]

Hi all,

Quite new to Power BI/Power Query with most of my knowledge coming from experimentation and using these forums, so please take that into consideration when responding. My current issue is as follows:

I am using this in the context of commerical real estate and want to assign a rank to a particular deal's annual rent wihtin the deal year (2018, 2019, 2020, etc,) as well as by deal type (new, renewal, option and move out). Basically, ranking the new leases, renewals, options and move outs by annual rent by year.

I have tried using combinations of the RANKX and FILTER functions, but it never comes out the way I need. Can someone provide guidance on how to think about this problem conceptually, and possibly some solutions of how to get a workable solution?

Thanks in advance.

[v-jingzhang]

Hi @_NewToPowerBI , see if these links help.

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

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

https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[Greg_Deckler]

@_NewToPowerBI See if this article helps, if not @ me in reply and post sample data and expected output.

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

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.