Forum Discussion

ukeasyproj's avatar
ukeasyproj
Icon for Helper II rankHelper II
9 years ago
Solved

need help with rankx

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

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

Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    ukeasyproj

     

    Use this dax:

     

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

    In visual level filter select

     

1 Reply

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    ukeasyproj

     

    Use this dax:

     

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

    In visual level filter select