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...
Need Help
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.

     

     

     

     

     

     

     

     

  • Coryanthony's avatar
    Coryanthony
    Helper III
    2 years ago

    Hello parry2k 

    any suggestions on this?