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

[Tishchenko]

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

Thanks!

[Greg_Deckler · Accepted solution]

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

[Anonymous]

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