Group list of names by percentage

[skourtip]

Hi to all i have this list of names sorted by total and i want to make 3 groups big, medium, low. The first group (big) i want to have first 20% of the names the second(medium) the next 60% and third(low) the rest 20% of the names is this possible?

NAMES	Total
name1	994
name2	144
name3	116
name4	78
name5	32
name6	12
name7	5
name8	3
name9	3
name10	2
name11	1
name12	1
name13	1

[skourtip]

Is it possible to have three different numbers?

[Greg_Deckler]

@skourtip Maybe try 2 columns:

Rank = RANKX('Table2',[Total],,ASC)


Category = 
    VAR __Max = MAX('Table2'[Rank])
    VAR __Rank = [Rank]
    VAR __Percent = DIVIDE(__Rank,__Max,0)
RETURN
    SWITCH(TRUE(),
        __Percent >= .8,"Big",
        __Percent <= .2,"Low",
        "Medium")

[skourtip]

I think its super thank yoy Greg one more question, if i want to change the percentages? i see number only in big and low, how about medium?