Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.