Access the top n% rows of a dataset

[Anonymous]

How could I simply make a new column called 'Quintile' and assign each row a value 1-5 where the top 20% of rows are assigned 1 in 'Quintile', the next 20% are assigned 2, and so on? Assume that the values I am evaluating are sorted in descending order already, as so why I just need to slice the data apart at these cutoffs and access the row counts accordingly.

[Anonymous · Accepted solution]

For anyone that comes across this problem I created new columns that calculated each quintile cutoff. Then I created a final quintile column and used this to assign quintile tags. 

Calc Quintile = IF('KPI Active'[Productivity Score]>='KPI Active'[Calc Q1 Cutoff],1, IF(AND('KPI Active'[Productivity Score]>='KPI Active'[Calc Q2 Cutoff], 'KPI Active'[Productivity Score]<'KPI Active'[Calc Q1 Cutoff]),2, IF(AND('KPI Active'[Productivity Score]>='KPI Active'[Calc Q3 Cutoff], 'KPI Active'[Productivity Score]<'KPI Active'[Calc Q2 Cutoff]),3, IF(AND('KPI Active'[Productivity Score]>='KPI Active'[Calc Q4 Cutoff], 'KPI Active'[Productivity Score]<'KPI Active'[Calc Q3 Cutoff]),4, IF('KPI Active'[Productivity Score] < 'KPI Active'[Calc Q4 Cutoff],5, 00 )))))

[m3tr01d]

Hi @Anonymous 
how many rows and columns do you have in that table?

[Anonymous]

It is going to depend for each time I update it, was hoping to get some help by using countrows / 5, then assigning quintiles in that fasion where number of rows and columns are just variables