Forum Discussion

el_lloydie's avatar
el_lloydie
New Member
10 years ago
Solved

Ranking help please

Hi guys   I'm very new to this so I could well be running before I can walk.   I essentially have a table that details suppliers with a monthly performance score.   Can anyone help me with a fo...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    10 years ago

    Hi EL_lloydie,

     

    According to your description, you need to background sort them by score and get the top 10 suppliers, and display them order by jobs raised, right?

     

    I have tested it on my local environment, the steps below is for you reference.

     

    1. Click Edit Queries > Edit Querie
    2. Click arrow in Overall Score column > Sort Descending
    3. Click Keep Rows > Keep Top Rows, type 10 in the Number of rows textbox.
    4. Click Close & Apply button
    5. Create a calculated column using the DAX below.
      Rank = RANKX(Supplier,Supplier[Job Raised])
    6. Then display the data on the visuals.

    Regards,

    Charlie Liao

el_lloydie's avatar
el_lloydie
New Member
10 years ago

Thanks Achin

 

It sort of works, only I can't understand the rankings!

 

Below is my data (admittedly, sorted by score (high to low).

 

I need it to background sort them by score (high to low) and then by jobs raised (so that it goes high to low). Then the supplier at the top would be ranked 1, the next supplier would be 2 and so on.

 

 

Thanks,

Gareth

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
10 years ago

Hi EL_lloydie,

 

According to your description, you need to background sort them by score and get the top 10 suppliers, and display them order by jobs raised, right?

 

I have tested it on my local environment, the steps below is for you reference.

 

  1. Click Edit Queries > Edit Querie
  2. Click arrow in Overall Score column > Sort Descending
  3. Click Keep Rows > Keep Top Rows, type 10 in the Number of rows textbox.
  4. Click Close & Apply button
  5. Create a calculated column using the DAX below.
    Rank = RANKX(Supplier,Supplier[Job Raised])
  6. Then display the data on the visuals.

Regards,

Charlie Liao