Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Dax for return TOP 1 region name

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

 

RegionRankx Docs Upload POD %
North80.00%
Rajasthan80.00%
Tamil Nadu113.00%
Madhya Pradesh75.00%
Kerala65.20%
East56.10%
West47.20%
Andra Pradesh37.40%
Karnataka27.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

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_1-1697463916406.png

 

 

Jihwan_Kim_0-1697463902283.png

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

1 REPLY 1
Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_1-1697463916406.png

 

 

Jihwan_Kim_0-1697463902283.png

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.