need help with rankx

[ukeasyproj]

Hey I am wondering if rankx can be used in the following case:

Basically I want to see the top 3 projects with the most logged hours for a given portfolio:

the final result should look like this:

Portfolio  | Project | Hours Logged

---------------------------------------

Portfolio 1 |  project 1 | 10000

---------------------------------------

Portfolio 1 |  project 8 | 5000

---------------------------------------

Portfolio 1 |  project 9 | 2000

---------------------------------------

Portfolio 2 |  project 0 | 15000

---------------------------------------

Portfolio 2 |  project 3 | 7000

---------------------------------------

Portfolio 2 |  project 11 | 2000

---------------------------------------

[Vvelarde · Accepted solution]

@ukeasyproj

Use this dax:

Ranking =
RANKX (
    ALLEXCEPT ( Table1, Table1[Portfolio] ),
    CALCULATE ( SUM ( Table1[HoursLogged] ) ),
    ,
    DESC,
    DENSE
)

In visual level filter select