Forum Discussion
RANKING in Power BI Desktop !!
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 ...
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.
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 !