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.
Hello,
I have a table with many columns, among which are Area and the Value. I want to rank the Areas by the Sum of Value. I have created Total Value measure which is a simple SUM of Value. Then I have created these two Rankx measures, which are similar but the first one sort DESC and the second one ASC.
See in the screenshot what I get:
So it works for only 1 Area and all other areas have the same rank value, either 1 or 75 (which is the count of areas -1)
:((((
Solved! Go to Solution.
Hi, @Sab ;
I tested it ,and it is right .can you share your [Total Value] 's measure ,may be it will helpful to this error.
Rank asc = RANKX(ALL('Table'),[Total value],,ASC)
Or could you make a simple data and share with us?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Sab
Use ALLSELECTED ( 'ALL'[AREA] ) instead of ALL ( 'ALL'[AREA] ) inside your RankX function
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Still same result:
@Sab
Without enough information, it's hard to make assumptions. make dummy files with sample data and share them.
Check your data model and the relationships.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hey @Sab ,
the formula looks good.
Can you share the file? There must be something wrong.
Hi, unfortunately I can't share it 😞
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |