The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
54 | |
42 | |
23 | |
23 | |
18 |