TOPN of averages

[Anonymous]

Hi guys i've seen a lot of posts about averageing the TOPN values, but in my case i want TOPN to show me in a Card the best performing [Specification] in terms of their average [total hours].

I've been playing with this but it returns a blank.

Top Specification =

calculate(SELECTEDVALUE('Batch Details'[Specification]),

TOPN(1, ALL('Batch Details'),AVERAGEX(TOPN(1,'Batch Details','Batch Details'[Total Hours],DESC),'Batch Details'[Total Hours]),DESC))

How can i manage this? I'd like perhpas 3 x different cards showing me the best specifications in terms of their average total hours.

Thanks in advance.

[Anonymous]

Thanks Amit. I'm fine with the average calculation. I just wanted to show on a card the specification that relates to the highest average. The workaround i've found waas to use a table instead and filter it with a RankX on the average.

[amitchandak]

@Anonymous , Try measures like

total Hours = sum('Batch Details'[Total Hours])

TOP 10/N =

CALCULATE(averageX(VALUES('Batch Details'[Specification]),[total Hours ]),TOPN(10,all('Batch Details'[Specification]),[total Hours],DESC))