Power BI conditional indexing

[crdok]

Hi, I am trying to index some countries in a table based on values from a column. So for example : I have a list of 5 countries ( AU, BR, CA, CH, CL); If AU has the maximum value in column (notional) then I would like to get an index of 1 for it. If the second max value in column ( notional) is CA, then I would like it to be indexed with 2 and so on and so forth. Is this possible ? Many thanks 

[crdok]

Hi, I would like to index a category ( in this case countries) based on the values in another column ( notional). For example: we have a column which has 5 countries ( AU, BE,DE,AT,CN,TH); If the maximum value in column notional is for AU then I would like to assign index number one to it. If the second maximum value in notional is for AT then  index value for AT should be 2, and so on and so forth. Is this possible? Thank you 

[Greg_Deckler]

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

[TomMartens · Accepted solution]

Hey,

what you are looking for can be achieved using the DAX function RANKX(), that is described here:

https://msdn.microsoft.com/en-us/query-bi/dax/rankx-function-dax

If you need more help, just search for RANKX in this forum.

If you do not find your answer, consider to create a little pbix file, upload the file to Onedrive or dropbox and share the link.

Hopefully this gets you started.

Regards,

Tom