Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
Solved! Go to 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
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
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])
Instead of a measure use a calculated column
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 |
Hello Sandra,
The second argument must be a Measure or must be surrounded by a CALCULATE() function.
Si quieres lo comentamos en castellano.
Saludos
the second argument is already a measure
thanks
If i put a calculated column I get an error....
thanks so much!!