Forum Discussion

MattN4's avatar
MattN4
Icon for Helper I rankHelper I
8 years ago
Solved

Top salesperson

Hi all,   Another simple ask.   In the service (so no DAX) I am trying to show the top sales person by region. I have all the measures I need, but it seems impossible to use the Top N. Each regio...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi MattN4

    Do you want to show the top 1 sales person from each region?

    If you create a rank measure, than you can filter the "rank" to show values of 1.

     

    Below is my example.

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi MattN4

Do you want to show the top 1 sales person from each region?

If you create a rank measure, than you can filter the "rank" to show values of 1.

 

Below is my example.

 

Best Regards

Maggie

  • MattN4's avatar
    MattN4
    Icon for Helper I rankHelper I
    8 years ago

    Many thanks this worked.

     

    Just to add, I added DENSE to the end of formula. This was because in my table I had both positive and negative values. The postive values were fine, the negative values showed out of sequence. DENSE resolved this (but don';t ask me how!).