Forum Discussion

Coryanthony's avatar
Coryanthony
Helper III
2 years ago

Help with Top4 Average

Hello All,

I need the fine the average audits per hour for the Top 4 auditors.

 

Line Items Actioned = COUNT('All Actioned'[Report Legacy Key])

Line Items Audited = CALCULATE([Line Items Actioned], 'All Actioned'[Selected for Audit] = 1)

Total Hours = SUM('Time Utilization'[Hours])

Hours Audit = CALCULATE([Total Hours], 'Time Utilization'[Stage] = "F&A-TE-Audit")

Hourly Audit = DIVIDE([Line Items Audited], [Hours Audit] ) .

 

 

I cannot seem to get an accurate average for the top 4 auditors. please help. 

Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    Coryanthony what is the relationship between  All Actions and Time utilization table? Also, do you have a dimension table for auditors?

    • Coryanthony's avatar
      Coryanthony
      Helper III
      2 years ago

      Hi parry2k 

      Thank you for your time. I do have a dimension table (Auditor Names') for the auditors and a Calendar dimension table.

      All Actioned and Time Utilization table does not have a direct relationship. Both tables has a relationship with Calendar and Auditor Names Table.