Forum Discussion

pva's avatar
pva
Frequent Visitor
4 years ago
Solved

RANKING

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 Resuta...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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