Retrieving Details of Rank 1 Row

[Ababneh]

Hey all, this is my second message, which the first one was very successful thanks to the best members for the world 🙂

Okay, What I have done is get the top rank of employees based on there average score (because they try more than once):

Employee ID	Name	Email	Score
3167	Henry Henry	henryhenry@email.com	35
1412	Joseph Joseph	josephjoseph@email.com	30
3142	Michael Michael	michaelmichael@email.com	28
1312	Sam Sam	samsam@email.com	27
1231	George George	georgegeorge@email.com	23
3167	Henry Henry	henryhenry@email.com	35
1412	Joseph Joseph	josephjoseph@email.com	30
3142	Michael Michael	michaelmichael@email.com	28
1312	Sam Sam	samsam@email.com	27
1231	George George	georgegeorge@email.com	23
3167	Henry Henry	henryhenry@email.com	35
1412	Joseph Joseph	josephjoseph@email.com	30
3142	Michael Michael	michaelmichael@email.com	28
1312	Sam Sam	samsam@email.com	27

What I did to get the first rank is:

1. Make a new measure:
   • Average Score = AVERAGE(Sheet1[Score])
2. Then a new measure to rank them: 
   • Score Rank = CALCULATE(RANKX(ALLSELECTED(Sheet1[Name]),[Average Score],,0,Dense))
3. It gave rank 1 to Henry Henry

What I want is, to make 2 cards, one card has the highest "Average Score" (Score Rank = 1) (35), and another card with the name of the highest "Average Score" (Score Rank = 1) (Henry Henry).

Tried doing this: Adding the name to the card as "Fields" and then add "Score Rank" measure to "Visual Level Filters" to equel it as 1 to give me the name of "Henry Henry", but for some reason, it won't let me edit "Score Rank"

A bit of detail to your answer would be appreciated.

Thank you guys, I'm have been trouble I know 🙂
Thanks again.

[Ababneh]

No one? Please I need your help!

[TomMartens]

Hey,

I had my issues with the card visual myself.

But I was able to use a simple column chart, in your case you would use name on the axis and average score as value, use score rank as visual filter, then you have to start playing with the formatting options of the column chart, eg

• hiding the y axis
• and other stuff like that

Hope this helps somehow

Regards

Tom

[Ababneh]

There is bar showing... How can I make a column that calculates summation then another column that averages it based on the name not total values, then another column to Rank them, then when I add a card then add a column as a filter I can manipulate it.

[TomMartens · Accepted solution]

Hey,

Please excuse, but I do not understand the requirement you describe in your latest post, I was able to solve a similar requirement like yours, using two visulas by using a clustered column chart, instead two cards I used one chart, here is the result

If this is what you are looking inspect the formating options of the chart, the pbix file is here have a look at report page 2.

If it's not what you are looking for, please provide some sample data (sharing a link to your pbix on onedrive or sharepoint) and it would by really helpful if you also share some images, how your chart / visuals should look like.

Regards

Tom

[Ababneh]

It worked just how I wanted it 🙂 Thanks