Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hola,
Intento hacer un ranking con con condicional. Tengo la siguiente información
PAIS | VALOR | RANKING (Resultado buscado) |
US | 3 | 1 |
US | 4 | 1 |
CHINA | 1 | 2 |
CHINA | 2 | 2 |
MEXICO | 7 | 4 |
PANAMA | 3 | 5 |
COLOMBIA | 10 | 3 |
US | 18 | 1 |
US | 9 | 1 |
CHINA | 20 | 2 |
Aplique la siguiente expresión:
RANKX(ALL(TABLA[PAIS]),TABLA[VALOR],,DESC)
por repuesta solo obtengo = 1
¿qué expresión puedo aplicar?
Muchas Gracias,
Himeris
Solved! Go to Solution.
For Rank Refer, if these links can help
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
For Rank Refer, if these links can help
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |