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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.