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

amitchandak's avatar
amitchandak
Super User
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

Coryanthony's avatar
Coryanthony
Helper III
2 years ago

Hey amitchandak 

Thank you for your response. It appears i am getting an error.

First -  Calculate([Hourly Audit], keepfilters(TOPN, 4, ALL('All Actioned'[Auditor]),[Hourly Audit], desc))
Results: The syntax for ',' is incorrect. (DAX(Calculate([Hourly Audit], KEEPFILTERS(TOPN, 4, ALL('All Actioned'[Auditor]),[Hourly Audit], desc)))).

Second - 

Top 4 Auditors = Calculate(AVERAGE(values('All Actioned'[Auditor]) , [Hourly Audit]) , KEEPFILTERS(TOPN, 4, ALL('All Actioned'[Auditor]),[Hourly Audit], desc))


Results: The syntax for ',' is incorrect. (DAX(Calculate(AVERAGE(values('All Actioned'[Auditor]) , [Hourly Audit]) , KEEPFILTERS(TOPN, 4, ALL('All Actioned'[Auditor]),[Hourly Audit], desc)))).