Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to drive the Top/Bottom 10 Customers.

Hi Team,   We have customers more than 100 and we would like to take the Top 10 customers and bottom 10 customers based on the contribution figures. Can anyone please help with formulas/measures t...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    For your requirement, you could try this way as below:

    Step1:

    Create two rank measure for [Contribution] measure

    Rankx asc= RANKX(ALL('Table'[Customer Short]),[Contribution],,ASC)
    Rankx desc = RANKX(ALL('Table'[Customer Short]),[Contribution],,DESC)

    Step2:

    Create a conditional measure that shows Top/Bottom 10 Customers.

    In my simple sample, I just show Top/Bottom 2 Customers

    Top/bottom 2 Customers = IF([Rankx asc]<=2||[Rankx desc]<=2,[Contribution])

    Result:

    and here is my sample pbix file, please try it.

     

    Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous 

For your requirement, you could try this way as below:

Step1:

Create two rank measure for [Contribution] measure

Rankx asc= RANKX(ALL('Table'[Customer Short]),[Contribution],,ASC)
Rankx desc = RANKX(ALL('Table'[Customer Short]),[Contribution],,DESC)

Step2:

Create a conditional measure that shows Top/Bottom 10 Customers.

In my simple sample, I just show Top/Bottom 2 Customers

Top/bottom 2 Customers = IF([Rankx asc]<=2||[Rankx desc]<=2,[Contribution])

Result:

and here is my sample pbix file, please try it.

 

Regards,

Lin