Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Top 5 help

Hello,

 

What I am looking to do is rank the business sponsors in order of who has the most active projects open. I would assume I would have to sum the custom column as it represents the project  but not sure of the logic for the top 5. Any suggestions?

 

Business sponsor      custom

  A                                                 1

  B                                                 1

  C                                                 1

  B                                                 1

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Create whatif parameter,

    then create measures

    Measure =
CALCULATE (
    SUM ( 'Table'[custom] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Business sponsor]
            = MAX ( 'Table'[Business sponsor] )
    )
)

Measure 2 = RANKX(ALLSELECTED('Table'),[Measure],,DESC,Dense)

Measure 3 = IF([Measure 2]<=[TOP 5 Parameter Value],1,0)

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies