Top 10 and others

[bml123]

Hi,

I have data like this

Client	Sales
A	100
B	20
C	40
D	50
E	60
F	10
G	5

I want to show top 3 customers and group the rest into others.

I have created rank measure like this 

RANKX (

        ALLSELECTED (Table[Client] ),

        CALCULATE ( Sum[Sales] ) ),

        ,

        DESC,

        DENSE

    )

but not able to get the final output.

How do I achieve that?

[johnt75]

SQL BI have a great article on this.