March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I'm looking for a way to rank all values independend if that are on the first level or second level of my hierarchy.
This is the hierarchy:
Area | Country |
AuNZ | Australia |
AuNZ | New Zealand |
Canada | Canada |
Europe | Belgium |
Europe | Germany |
Europe | France |
UK | UK |
Some levels in my hierarchy have blank values:
Value | Rank | |
AuNZ | 65.1% | 2 |
Australia | <blank> | |
New Zealand | <blank> | |
Canada | 70.1% | 1 |
Canada | <blank> | |
Europe | <blank> | |
Belgium | 60.8% | 3 |
Germany | 25.7% | 5 |
France | 10.0% | 6 |
UK | 30.0% | 4 |
UK | <blank> |
As you can see, values are blank for all countries, except for the countries in Europe. Also for Europe itself the value is blank.
I created this measure to get the right values at the right place:
Thanks for sharing these examples! Problem is that all these rank at each level of the hierarchy and not across the levels of the hierarchy (or perhaps I missed that).
I'll prepare an example PIBX. I cannot share the current version.
Thanks
Kris
Hi @Krispi ,
You can refer to the following posts that may be helpful to you:
Rankx in Matrix Hierarchy - Microsoft Fabric Community
Rankx Multiple levels to Hierarchy - Microsoft Fabric Community
Power BI Ranking In Hierarchical Form (enterprisedna.co)
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
62 | |
27 | |
25 | |
22 | |
16 |