Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sandeepraichura
Regular Visitor

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 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

 

 

5 REPLIES 5
Twan
Advocate IV
Advocate IV

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)

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.

 

 

 

Untitled picture.png

 

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
Impactful Individual
Impactful Individual

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

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors