Rank by an average over a period

[Wisselaar]

I need to give a table wich contains top 10 error % over the last year. So I understood I need a ranking. But can't get it to work:

The average is in column 'Avg Error %' and is now sorted. In the column after I need the rank.

I used: 
RANK Avg Error % =
RANKX( ALLSELECTED(ErrorTotalsDay[DtKey_Checkdate]); CALCULATE(AVERAGE(ErrorTotalsDay[Error % Day]));;ASC)

[Anonymous · Accepted solution]

Hey @Wisselaar Create these measures

Avg error = Avg(error)

Rank Avg Error = rankx(allselected(rulekey),[Avg error],,desc

Post this, drag this measure in table and in the filter pane just apply a filter that this measure should be less than 11, and it will always show top 10 records.

[Wisselaar]

The TOP N Filter option isn't there.

[lkalawski]

Hi @Wisselaar 

You don't need to create a Rank measure. You can use the filter panel and add a condition to show only TOP 10 values based on the Avg. Error % measure. 

_______________
If I helped, please accept the solution and give kudos! 😀