cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tishchenko
Continued Contributor
Continued Contributor

Please, add "TopN" filter in standart list of filters "Show items where the value:"

Please, add "TopN"  filter in standart list of filters "Show items where the value:"

 

Thanks!

 

topN.png

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

You can achieve this by creating a column or measure using RANK or RANKX and filtering it based upon "Is Greater Than".


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

You can achieve this by creating a column or measure using RANK or RANKX and filtering it based upon "Is Greater Than".


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

Hi,

 

I have a scenario where the table contains columns {Service, Country, Amount}. I want to rank the rows based on the amount for each country, service combination.

 

When I use the Rankx function with the following syntax, the new column is set with "1". What am I missing ? Any assistance in this will be appreciated.

 

Sheet1 is the name of the table.

 

Column = Rankx(All(Sheet1[Country],Sheet1[Service]),Sheet1[Amount], Sheet1[Amount]) 

 

Please note that I am using PowerBI Desktop (GA from Jul, 2015) and publishing to www.powerbi.com. The datasource is an excel file.

 

Thanks,

Ashish

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors