RANKING in Power BI Desktop !!

[sandeepraichura]

I want to Rank the Accounts by their Revenue and I don't see the RANKX function in Power BI Desktop.  Is there an alternative to this ?  One Customer has multiple accounts and I want to rank all the accounts by their Revenue, and when I switch the filter to another Customer, It should list the accounts and their ranking by their revenue.  Is this possible in Power BI Desktop ?

Read about the RANKX function but it doesn't seem to work on Power BI Desktop, Please help

[Twan]

The RANX function works in Power BI desktop.  If you provide the formula you came up with along with the table and columns names from your model that would be part of the ranking formula then people will be able to help more.

Your RANX filter should look something like this based on the information your provided (I don't know what your table name is so I just used Table1 in the example):

=RANKX(FILTER('Table1', 'Table1'[Customer] = EARLIER([Customer])), [Revenue], ,0)

[sandeepraichura]

sure, I'm using a direct query to create a connection from Power BI Desktop to SQL Server.  When I click on New Measure and enter RANKX, it doesn't work.  For some reason, RANKX is not recognized.  Am i doing anything wrong ?

here's the picture of a list of accounts and their revenue in excel, I want to create a ranking by revenue for each account.  I want to add a slicer named Account Manager, so when I click on Acocunt Manager it should only list the accounts that he is responsible sorted by the revenue.

[sandeepraichura]

[sandeepraichura]

RANKX seem to be working now !  Since I'm using the Direct Query mode, I had to update the settings as listed here.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/

Thanks All for your help !

[austinsense]

Do you 1) not see the function or 2) is it not working correctly - if #2, please provide your DAX