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_AnioAnt_vs_Budget_BI);da_Ventas_vs_AnioAnt_vs_Budget_BI[Total Ventas 16 Pop])

but it doesn't works, I dont have any filter but it returns 1 to the first 23 rows althought they have different values

Any idea??

thanks so much!!

  • 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

7 Replies

  • sandrasanchez's avatar
    sandrasanchez
    Advocate I
    10 years ago
    CNH & hospitalTotal Ventas Actual PopRank ventas HospitalesCNH & hospital,Total Ventas Actual Pop,aRank ventas Hospitales
    019002M, Profarco Cofares109435006.21019002M, Profarco Cofares,109435006.2,1
    008001Z, Laboratorios Dr. Esteve- S.A.69240209.151008001Z, Laboratorios Dr. Esteve- S.A.,69240209.15,1
    030002M, Reguladora De Compras Del43635336.721030002M, Reguladora De Compras Del,43635336.72,1
    0410016, Hospital Virgen Del Rocío14285865.8710410016, Hospital Virgen Del Rocío,14285865.87,1
    0280072, Hospital Clínico San Carlos13874715.0310280072, Hospital Clínico San Carlos,13874715.03,1
    0460018, Hospital Universitari I Politècnic La Fe13174949.8110460018, Hospital Universitari I Politècnic La Fe,13174949.81,1
    028014M, Bk_Abbott Laboratories Sa12221749.641028014M, Bk_Abbott Laboratories Sa,12221749.64,1
    008002M, Alliance  Healthcare  España Sa11344504.91008002M, Alliance  Healthcare  España Sa,11344504.9,1
    017001C, Ferrer Internacional Sa11114574.21017001C, Ferrer Internacional Sa,11114574.2,1
    041001M, Cecofar- Sdad. Coop. Fca. Lda.11007413.481041001M, Cecofar- Sdad. Coop. Fca. Lda.,11007413.48,1
    0080018, Hospital General Univ Vall D'Hebron10545674.2510080018, Hospital General Univ Vall D'Hebron,10545674.25,1
    0280035, Hospital Universitario 12 De Octubre10366276.7810280035, Hospital Universitario 12 De Octubre,10366276.78,1
    050001M, Aragofar Sdad Coop10151168.251050001M, Aragofar Sdad Coop,10151168.25,1
    033002M, Cooperativa Fca Asturiana10146026.821033002M, Cooperativa Fca Asturiana,10146026.82,1
    0410042, Hospital Virgen Macarena971212410410042, Hospital Virgen Macarena,9712124,1
    0150026, Hospital Universitario A Coruña9451742.9110150026, Hospital Universitario A Coruña,9451742.91,1
    0280014, Hospital Universitario La Paz9449711.5310280014, Hospital Universitario La Paz,9449711.53,1
    0500021, Hospital Universitario Miguel Servet9224834.2310500021, Hospital Universitario Miguel Servet,9224834.23,1
    0150217, Hospital Clínico Universitario9107097.1810150217, Hospital Clínico Universitario,9107097.18,1
    0080109, Hospital Clínic I Provincial De Barcelona9065082.110080109, Hospital Clínic I Provincial De Barcelona,9065082.1,1
    0140044, Hospital Reina Sofía8971634.0110140044, Hospital Reina Sofía,8971634.01,1
    035001M, Coop  Fca Canaria - Cofarca8924231.41035001M, Coop  Fca Canaria - Cofarca,8924231.4,1
    008010M, Federacio Farmaceutica-S.Coop. C.L.8736390.481008010M, Federacio Farmaceutica-S.Coop. C.L.,8736390.48,1
    029003M, Cofaran8562648.081029003M, Cofaran,8562648.08,1
    0310150, Complejo Hospitalario De Navarra8549123.8310310150, Complejo Hospitalario De Navarra,8549123.83,1
    0390015, Hospital Universitario Marqués De Valdecilla8408756.4910390015, Hospital Universitario Marqués De Valdecilla,8408756.49,1
    0280246, Hospital General Universitario Gregorio Marañón8277677.5410280246, Hospital General Universitario Gregorio Marañón,8277677.54,1
    0200261, Hospital Universitario Donostia-Donostia Unibertsitate Ospitalea8177859.8610200261, Hospital Universitario Donostia-Donostia Unibertsitate Ospitalea,8177859.86,1
    0330292, Hospital Universitario Central De Asturias8168707.4910330292, Hospital Universitario Central De Asturias,8168707.49,1
    019003M, Farmavenix8120272.321019003M, Farmavenix,8120272.32,1
    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hello Sandra,

       

      The second argument must be a Measure or must be surrounded by a CALCULATE() function.

       

      Si quieres lo comentamos en castellano.

       

      Saludos

  • 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])