Forum Discussion

Boycie92's avatar
Boycie92
Icon for Resolver I rankResolver I
9 years ago
Solved

RANKX Help

Hi   I was wondering if someone could help me.   I want to create a measure that will work based on the following conditions:   I want it to show the top 4 Highest Performers and filter out eve...
Need Help
Tips and Tricks
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Boycie92

     

    Since you always want to include that specific person in "the four", you need to exclude that person in the dataset and rank the top 3 first, then UNION that person together. 

     

    Regards,

Boycie92's avatar
Boycie92
Icon for Resolver I rankResolver I
9 years ago

Hi v-sihou-msft,

 

Thanks for your response.

 

I already have the specific person within the data set. Do I still need to follow the process you recommended or can I just use the TOPN() function?

 

Thanks,                                                                                                                                                                                      

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Boycie92

 

Since you always want to include that specific person in "the four", you need to exclude that person in the dataset and rank the top 3 first, then UNION that person together. 

 

Regards,