Get the best and the worst customers back depending when they are paying

[Anonymous]

I Have a table where there is a column with Delay of Payment days. I want to filter this Column and get the top 5 highest and the top 5 lowest number of the column. ( The table is big, it has approximately 15000 rows.)

[johnt75 · Accepted solution]

It depends on what you want to do with the information. If its just for a table visualisation or similar then in the filter pane you can use a Top N filter and select whether to show the top or bottom rows.
If you need to perform calculations on just the top and bottom people, in DAX you can use TOPN.