topic Re: TOPN of averages in DAX Commands and Tips

TOPN of averages

Anonymous — Mon, 03 May 2021 23:36:04 GMT

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.

Re: TOPN of averages

amitchandak — Tue, 04 May 2021 02:51:42 GMT

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))

Re: TOPN of averages

Anonymous — Thu, 13 May 2021 01:58:15 GMT

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.