Forum Discussion

scaballerom's avatar
scaballerom
Icon for Helper I rankHelper I
3 years ago
Solved

Top 10 Ranked Average

Hi all, I have the following measure: AvgDuration = IF(SUM(Fact Jobs'[job_elapsed_min])>0 && ISBLANK([SUM(Fact Jobs'[job_elapsed_min]))=FALSE,AVERAGE('Fact Jobs'[job_elapsed_min]))   What I ...
AvgTopN
DAX
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

scaballerom , Try measure like

 

AverageX(keepfilters(topn(10, allselected('Fact Jobs'[AvgDuration]) ,_roll18, desc)),[AvgDuration])

 

or

 

 

calculate(AverageX(Values('Fact Jobs'[job_name]),[AvgDuration]),topn(10, allselected('Fact Jobs'[job_name]) ,[AvgDuration], desc))