Forum Discussion

Coryanthony's avatar
Coryanthony
Helper III
2 years ago
Solved

Top 4 Average

Hello All, I want to find the average audits per hour for the top 4 Auditors. I have my average Audits per hour. Please help   Line Items Actioned = COUNT('All Actioned'[Report Legacy Key]) Line ...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Coryanthony , Try meausre like

    Calculate([Hourly Audit], keepfilter(TOPN, 4, ALL('All Actioned'[Auditor]),[Hourly Audit], desc))

     

    I do not think you need another avg as divide is avg only or try

     

     

    Calculate(averaged(values('All Actioned'[Auditor]) , [Hourly Audit]) , keepfilter(TOPN, 4, ALL('All Actioned'[Auditor]),[Hourly Audit], desc))

    Power BI: rankx, topn, dynamic topn with numeric parameters
    https://youtu.be/cN8AO3_vmlY?t=25620

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Share the download link of the PBI file.

Coryanthony's avatar
Coryanthony
Helper III
2 years ago

Thank you Ashish_Mathur 

 

i was able to get the right measure - 

= CALCULATE([Hourly Audit], TOPN(4,ALLSELECTED('Auditor Names'[Auditor]),[Hourly Audit],DESC), VALUES('Auditor Names'[Auditor]))