Top N and EARLIEST function in power bi

[Anonymous]

Hello,
AVG= CALCULATE( AVERAGE(FCCU[AVG]) ,FILTER(FCCU,FCCU[TS] = EARLIEST( FCCU [TS]) && TOPN(1,FCCU)))
I am trying for this give me error for earlist function .I want output as earlist record of TS top 2 records and there average .
want to show them in a table

way ealiest function not working.....

[Anonymous]

hello,
can I do this in mesure..top 3 value and earliest ts (date) becouse i want to show that in a table so if i am directly filter that directly it will impact on hole table so i want to write measure.

regards
Pooja

[v-shex-msft]

HI @Anonymous,

Nope, topn filter not works for measure and earliest function only works in calculate column/table.

In my opinion, I'd like to suggest you use rankx function to write a measure to get rank value, then use it in visual level filter to achieve similar topn filter effect.(is less than or equal to 3)

Reards,

Xiaoxin Sheng