Forum Discussion

Coryanthony's avatar
Coryanthony
Icon for Helper III rankHelper 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
Coryanthony's avatar
Coryanthony
Icon for Helper III rankHelper 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.