Forum Discussion
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 ...
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
Hi Ashish_Mathur Thank you for your response.
It does not appear to accurate.
Top 4 Auditors sample = DIVIDE(SUMX(TOPN(4,VALUES('All Actioned'[Auditor]),[Hourly Audit],DESC),[Hourly Audit]),4)
Top 4 Auditors = Calculate(AVERAGEX(VALUES('All Actioned'[Auditor]),[Hourly Audit]), KEEPFILTERS(TOPN(4,ALL('All Actioned'[Auditor]),[Hourly Audit],DESC)))
I'd like to see the Average for the top 4 auditors with the highest [Hourly Audit]. For October, the top auditors were Operator 23, 21,38 and 29. I'd like to see their average.
If i can get their average, this would be the team hourly goal. Thank you
Hi,
Share the download link of the PBI file.
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]))