Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Please, add "TopN" filter in standart list of filters "Show items where the value:"
Thanks!
Solved! Go to Solution.
You can achieve this by creating a column or measure using RANK or RANKX and filtering it based upon "Is Greater Than".
You can achieve this by creating a column or measure using RANK or RANKX and filtering it based upon "Is Greater Than".
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