cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sandeepraichura Frequent Visitor
Frequent 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
austinsense Established Member
Established Member

Re: RANKING in Power BI Desktop !!

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 🙂
Twan Regular Visitor
Regular Visitor

Re: RANKING in Power BI Desktop !!

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

Re: RANKING in Power BI Desktop !!

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.

 

 

Highlighted
sandeepraichura Frequent Visitor
Frequent Visitor

Re: RANKING in Power BI Desktop !!

 

Untitled picture.png

 

sandeepraichura Frequent Visitor
Frequent Visitor

Re: RANKING in Power BI Desktop !!

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 !

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors