Remove a specific percentage of data from a table

[savulesc]

I have a table with this structure :

Ticket	Verification Time	Department
1	23	SW
2	45	SW
3	45	FR
4	12	RT
5	56	TY
6	2	RT
7	67	SW
8	22	SW
9	34	RT
10	22	RT

I want to remove from this table 10% of the tickets with the longest verification time. Multiple tickets can have the same verification time. So in the example from above ticket 7 will be removed. 

Is there a way i can do this?

[Tahreem24]

@savulesc Create a DAX Measure like below:

Measure =

VAR a_ = CALCULATE(MAX('Table'[Verification Time]),ALL('Table'))

RETURN CALCULATE(SUM('Table'[Verification Time]),FILTER('Table','Table'[Verification Time]<a_))

[savulesc]

I want the whole row to be removed , this implementation is not what i'm looking for.

[amitchandak]

@savulesc , I think you should consider

3 Ways to Scale Data to Remove Effects of Outliers

https://www.youtube.com/watch?v=Y3ahe3J3Zuo

or create a rank column

rankx(Table, [Verification],,desc, dense)

and filter rank based on number record

a new table

filter(addcolumn(Table, "Rank", rankx(Table, [Verification],,desc, dense) , "_cnt", countrows(Table) )/10, [Rank] >_cnt)

[savulesc]

I tried with the rank column but it's not working as expected. The rank is not the same for the same value.

Ticket	Verification Time	Rank
1	20	1
2	20	3

And when i put the filter on the visual the table become empty.