Forum Discussion

sandrasanchez's avatar
sandrasanchez
Advocate I
10 years ago
Solved

rankx

Hi,  I have a column of hospital names and in another column the sales in each hospital, I want to have a rank of hospitals and I have this measure: Rank ventas Hospitales = RANKX(All(da_Ventas_vs_...
  • Baskar's avatar
    Baskar
    10 years ago

    Hi,

     

    1. Have to create seperata measure

    Eg: Sum of Total Ventas Actual Pop = Sum(Total Ventas Actual Pop)

     

    2. Create Rank

    Eg: Rank = RankX(AllSelected(CNH & hospital),"Sum of Total Ventas Actual Pop",,DESC,Dense)

     

    It will solve your prob , if not let me know

Baskar's avatar
Baskar
Resident Rockstar
10 years ago

Hi,

 

1. Have to create seperata measure

Eg: Sum of Total Ventas Actual Pop = Sum(Total Ventas Actual Pop)

 

2. Create Rank

Eg: Rank = RankX(AllSelected(CNH & hospital),"Sum of Total Ventas Actual Pop",,DESC,Dense)

 

It will solve your prob , if not let me know

sandrasanchez's avatar
sandrasanchez
Advocate I
10 years ago

it worked!!!!!

Thanks so much!!!

this is my finaly measure:

 

Rank = RankX(AllSelected(da_Ventas_vs_AnioAnt_vs_Budget_BI[CNH & hospital]);
da_Ventas_vs_AnioAnt_vs_Budget_BI[Total Ventas Actual Pop];;DESC;Dense)

 

and Total Ventas Actual pop is a measure:

Total Ventas Actual Pop = SUM(da_Ventas_vs_AnioAnt_vs_Budget_BI[Sales '16 Net])