Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |