Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hola a todos!
Tengo una tabla como esta y necesito hacer un ranking como se muestra en la última columna ("Resultado"). ¿Cómo podría hacerlo?
Canal | TV Show | Horas de retransmisión | Resutado (valor buscado) |
BBC | Los Simpsons | 20 | 1 |
TV1 | Los Simpsons | 15 | 2 |
MTV | Los Simpsons | 12 | 3 |
BBC | Juego de tronos | 15 | 3 |
TV1 | Juego de tronos | 30 | 1 |
MTV | Juego de tronos | 22 | 2 |
Muchas gracias!
Solved! Go to Solution.
Hi @pva ,
You can create a measure as follows if you want the rankings to be dynamically displayed according to the slicer's options or filters...
Measure =
RANKX (
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[TV Show] = SELECTEDVALUE ( 'Table'[TV Show] )
),
CALCULATE ( SUM ( 'Table'[Horas de retransmisión] ) ),
,
DESC,
DENSE
)
Best Regards
Hi @pva ,
You can create a measure as follows if you want the rankings to be dynamically displayed according to the slicer's options or filters...
Measure =
RANKX (
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[TV Show] = SELECTEDVALUE ( 'Table'[TV Show] )
),
CALCULATE ( SUM ( 'Table'[Horas de retransmisión] ) ),
,
DESC,
DENSE
)
Best Regards
is this what you want?
Column = rankx(FILTER('Table','Table'[TV Show]=EARLIER('Table'[TV Show])),'Table'[Horas de retransmisión],,DESC)
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |