rankx

[sandrasanchez]

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 · Accepted solution]

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]

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

[Vvelarde]

Instead of a measure use a calculated column

[sandrasanchez]

CNH & hospital	Total Ventas Actual Pop	Rank ventas Hospitales	CNH & hospital,Total Ventas Actual Pop,aRank ventas Hospitales
019002M, Profarco Cofares	109435006.2	1	019002M, Profarco Cofares,109435006.2,1
008001Z, Laboratorios Dr. Esteve- S.A.	69240209.15	1	008001Z, Laboratorios Dr. Esteve- S.A.,69240209.15,1
030002M, Reguladora De Compras Del	43635336.72	1	030002M, Reguladora De Compras Del,43635336.72,1
0410016, Hospital Virgen Del Rocío	14285865.87	1	0410016, Hospital Virgen Del Rocío,14285865.87,1
0280072, Hospital Clínico San Carlos	13874715.03	1	0280072, Hospital Clínico San Carlos,13874715.03,1
0460018, Hospital Universitari I Politècnic La Fe	13174949.81	1	0460018, Hospital Universitari I Politècnic La Fe,13174949.81,1
028014M, Bk_Abbott Laboratories Sa	12221749.64	1	028014M, Bk_Abbott Laboratories Sa,12221749.64,1
008002M, Alliance  Healthcare  España Sa	11344504.9	1	008002M, Alliance  Healthcare  España Sa,11344504.9,1
017001C, Ferrer Internacional Sa	11114574.2	1	017001C, Ferrer Internacional Sa,11114574.2,1
041001M, Cecofar- Sdad. Coop. Fca. Lda.	11007413.48	1	041001M, Cecofar- Sdad. Coop. Fca. Lda.,11007413.48,1
0080018, Hospital General Univ Vall D'Hebron	10545674.25	1	0080018, Hospital General Univ Vall D'Hebron,10545674.25,1
0280035, Hospital Universitario 12 De Octubre	10366276.78	1	0280035, Hospital Universitario 12 De Octubre,10366276.78,1
050001M, Aragofar Sdad Coop	10151168.25	1	050001M, Aragofar Sdad Coop,10151168.25,1
033002M, Cooperativa Fca Asturiana	10146026.82	1	033002M, Cooperativa Fca Asturiana,10146026.82,1
0410042, Hospital Virgen Macarena	9712124	1	0410042, Hospital Virgen Macarena,9712124,1
0150026, Hospital Universitario A Coruña	9451742.91	1	0150026, Hospital Universitario A Coruña,9451742.91,1
0280014, Hospital Universitario La Paz	9449711.53	1	0280014, Hospital Universitario La Paz,9449711.53,1
0500021, Hospital Universitario Miguel Servet	9224834.23	1	0500021, Hospital Universitario Miguel Servet,9224834.23,1
0150217, Hospital Clínico Universitario	9107097.18	1	0150217, Hospital Clínico Universitario,9107097.18,1
0080109, Hospital Clínic I Provincial De Barcelona	9065082.1	1	0080109, Hospital Clínic I Provincial De Barcelona,9065082.1,1
0140044, Hospital Reina Sofía	8971634.01	1	0140044, Hospital Reina Sofía,8971634.01,1
035001M, Coop  Fca Canaria - Cofarca	8924231.4	1	035001M, Coop  Fca Canaria - Cofarca,8924231.4,1
008010M, Federacio Farmaceutica-S.Coop. C.L.	8736390.48	1	008010M, Federacio Farmaceutica-S.Coop. C.L.,8736390.48,1
029003M, Cofaran	8562648.08	1	029003M, Cofaran,8562648.08,1
0310150, Complejo Hospitalario De Navarra	8549123.83	1	0310150, Complejo Hospitalario De Navarra,8549123.83,1
0390015, Hospital Universitario Marqués De Valdecilla	8408756.49	1	0390015, Hospital Universitario Marqués De Valdecilla,8408756.49,1
0280246, Hospital General Universitario Gregorio Marañón	8277677.54	1	0280246, Hospital General Universitario Gregorio Marañón,8277677.54,1
0200261, Hospital Universitario Donostia-Donostia Unibertsitate Ospitalea	8177859.86	1	0200261, Hospital Universitario Donostia-Donostia Unibertsitate Ospitalea,8177859.86,1
0330292, Hospital Universitario Central De Asturias	8168707.49	1	0330292, Hospital Universitario Central De Asturias,8168707.49,1
019003M, Farmavenix	8120272.32	1	019003M, Farmavenix,8120272.32,1

[vlahoz]

Hello Sandra,

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

Si quieres lo comentamos en castellano.

Saludos

[sandrasanchez]

the second argument is already a measure

thanks

[sandrasanchez]

If i put a calculated column I get an error....

thanks so much!!