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.
So I have a table that shows countries. Now I want to get the top 3 countries that are most common in the column.
So I decided to play around with RANKX, seen multiple threads. Most 'helpful' one is http://community.powerbi.com/t5/Desktop/Ranking-Subjects/m-p/21663#M6731 this one. However, as you can see in the table, all it shows is rank number one.
What I've done in cc is COUNTA column. But in the rank column is this:
Measure: Measure = COUNT(Table1[Countries])
Rank Column: Rank = RANKX(ALLSELECTED(Table1), [Measure])
Any help is appreciated!
Solved! Go to Solution.
You can use this two measures for the ranking of the countries:
Total Rows:=COUNTROWS(Table1)
Top Countries := RANKX(ALL(Table1),[Total Rows],,,Dense)
You can use this two measures for the ranking of the countries:
Total Rows:=COUNTROWS(Table1)
Top Countries := RANKX(ALL(Table1),[Total Rows],,,Dense)
Yep, added the measure to the visual filter. Worked like charm. Sorting works great too! Thanks for the help
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.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |