Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone, I need help on dynamic ranking based on slicer selection
I have following database
Company Name | Question NO | Countrty | Score |
Acko | 1 | Argentina | 2 |
Acko | 1 | Brazil | 3 |
Acko | 1 | Peru | 3 |
Acko | 1 | Spain | 4 |
Acko | 1 | Spain | 4 |
Acko | 1 | Brazil | 2 |
Acko | 1 | Argentina | 3 |
Acko | 1 | Argentina | 1 |
Acko | 1 | Brazil | 2 |
MAX | 1 | France | 3 |
MAX | 1 | Italy | 1 |
MAX | 1 | Mexico | 3 |
MAX | 1 | Argentina | 5 |
MAX | 1 | Mexico | 2 |
MAX | 1 | Italy | 5 |
MAX | 1 | Peru | 2 |
MAX | 1 | Argentina | 1 |
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 | ||
Country | Score | Rank |
Argentina | 6 | 2 |
Brazil | 7 | 3 |
Peru | 3 | 1 |
Spain | 8 | 4 |
and if i choose max, the table should like this
Company Name: Max | ||
Country | Score | Rank |
Argentina | 6 | 1 |
France | 3 | 3 |
Italy | 6 | 1 |
Mexico | 5 | 2 |
Peru | 2 | 4 |
may anyone help me on this
Solved! Go to Solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |