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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.