Forum Discussion

kylerwimbush's avatar
kylerwimbush
Icon for Helper I rankHelper I
3 years ago
Solved

Get Top 10 Employees based On Total Score

I have a table with employee names called DTM Info, and the column is called Full Name. I have a measure called Total Score which is just every score added together. I want to create a measure to sho...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    HI,

    Thank you for your message, and please check the below screenshot and the attached pbix file.

    I amended to have a measure in the formula.

     

    Show top5 only V2: = 
CALCULATE (
    [Score total:],
    KEEPFILTERS (
        WINDOW (
            1,
            ABS,
            5,
            ABS,
            ALL ( 'Name'[Full Name] ),
            ORDERBY ( [Score total:], DESC )
        )
    )
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

HI,

Thank you for your message, and please check the below screenshot and the attached pbix file.

I amended to have a measure in the formula.

 

Show top5 only V2: = 
CALCULATE (
    [Score total:],
    KEEPFILTERS (
        WINDOW (
            1,
            ABS,
            5,
            ABS,
            ALL ( 'Name'[Full Name] ),
            ORDERBY ( [Score total:], DESC )
        )
    )
)

 

kylerwimbush's avatar
kylerwimbush
Icon for Helper I rankHelper I
3 years ago

That works, but it shows everyone elses names (not top 5) afterwards with a weird value. That doesn't matter if there is a way to limit the rows produced to 5. Is there a way that can happen? 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Thank you for your message, and please check the below picture and the attached pbix file.

    I am not sure if I understood your question correctly, but try to deselect unnecessary measures from the visualization.