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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
kapildua16
Frequent Visitor

Dynamic Ranking based on slicer selection

Hi Everyone, I need help on dynamic ranking based on slicer selection

I have following database

Company NameQuestion NOCountrtyScore
Acko1Argentina2
Acko1Brazil3
Acko1Peru3
Acko1Spain4
Acko1Spain4
Acko1Brazil2
Acko1Argentina3
Acko1Argentina1
Acko1Brazil2
MAX1France3
MAX1Italy 1
MAX1Mexico3
MAX1Argentina5
MAX1Mexico2
MAX1Italy 5
MAX1Peru2
MAX1Argentina1

 

I want if i choose any company name in slicer and want to show its score and rank 

for ex if choose acko in slicer then table should like this

Company Name: Acko 
CountryScoreRank
Argentina62
Brazil73
Peru31
Spain84

 and if i choose max, the table should like this

Company Name: Max 
CountryScoreRank
Argentina61
France33
Italy61
Mexico52
Peru24

 

may anyone help me on this

1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

@kapildua16 ,

Rank Measure = RANKX(ALLSELECTED(RankTable[Countrty]),[Total Score],,DESC)
 
Tahreem24_0-1694579926512.png

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

3 REPLIES 3
Tahreem24
Super User
Super User

@kapildua16 ,

Rank Measure = RANKX(ALLSELECTED(RankTable[Countrty]),[Total Score],,DESC)
 
Tahreem24_0-1694579926512.png

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Thanks @Tahreem24 

Dhairya
Solution Supplier
Solution Supplier

Hey @kapildua16 
Can you share the measure of which you are using to plot rank?

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors