Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi I have a table created rankx measure based on the Docs upload % for each region so i got output which is best performing region
| Region | Rankx | Docs Upload POD % |
| North | 8 | 0.00% |
| Rajasthan | 8 | 0.00% |
| Tamil Nadu | 1 | 13.00% |
| Madhya Pradesh | 7 | 5.00% |
| Kerala | 6 | 5.20% |
| East | 5 | 6.10% |
| West | 4 | 7.20% |
| Andra Pradesh | 3 | 7.40% |
| Karnataka | 2 | 7.90% |
Ths is the ranking measure which used
Rank Region = RANKX(
ALL(dim_branch master[REGION_DESC]),
Fact_POD[# Docs Uploaded POD%],,DESC)
Now i wanted return the top 1sst region "name" using dax
that means
from the above table we can see tamil nadu is ranked as 1 and app upload % is 13%, now i need help to create dax for top region name as tamil nadu
so if i put dax into card visual my output should as above condition tamil nadu
appreciate help on this
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 9 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 17 | |
| 12 |