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
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
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
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Kudoed Authors