Hello everyone,
I have included my DAX below; it is doing the math correctly, except it is not capturing the page level filter, which is multiple selections of Employee names. The goal is to show overall team average timesheet completion as an indicator of the accuracy of actual time data in other visualizations. I tried the Selectedvalue as a filter, but it doesn't work with multiple results. There are 7 employees on the team.
Can anyone help with a suggestion? Just fyi, the relationship in this model is on other columns.
Team Timesheet % = AVERAGEX('List Data',CALCULATE(AVERAGE('List Data'[Timesheet %]))) (Just to clarify I did try to add "FILTER('List Data','List Data'[Employee Name]=SELECTEDVALUE('Work Plan Summary'[Resource]) without success.
'List Data'[Timesheet %] is a clalculated column "Timesheet % = DIVIDE(CALCULATE(DISTINCTCOUNT('Timesheet Data'[End Date]),FILTER('Timesheet Data','Timesheet Data'[Description]='List Data'[Employee Name] && 'Timesheet Data'[End Date]>43466)),WEEKNUM(TODAY())-1)"
