Forum Discussion
Solved
Measure which excludes slicer selection?
Working on performance reporting for a team. We take the individual's output (units) for a month and compare it to the team's average units for the month. The tricky part is that the average used f...
You may refer to the post below.
Ok, I got this far:
IdvCheckAvg = calculate([TotalChecks],CALCULATETABLE(SUMMARIZE(team, Team[EmployeeName])),USERELATIONSHIP(Team2[EmployeeName],Team[EmployeeName]),EXCEPT(values(Team2[EmployeeName]),values(Team[EmployeeName])))
Using this link:
It still doesn't work though, but I think I'm close. Any help on the DAX would be appreciated! Thanks!
You may refer to the post below.