The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
8 | |
8 |