You can approach this by using DAX functions and a few design techniques to control how your report behaves at different levels. The key is to use the REMOVEFILTERS function to step up the aggregation level so you can display the overall team results alongside an individual’s performance. For example, you can calculate a team total by wrapping your existing measure with REMOVEFILTERS on the teammate column, which clears the individual context but still respects any other filters like date or department. If you want to keep slicers such as date active while ignoring the teammate selection, try using ALLSELECTED instead.
It’s also important to make sure your model reflects the right hierarchy between agents, supervisors, and centers. That way, when you filter by a supervisor, the team-level visuals will automatically adjust without needing separate manual filters. For the visuals themselves, using multi-card visuals or small multiples can help you show individual, team, and overall results in one place without creating extra queries or performance overhead.
You might also want to manage visual interactions so that selecting one teammate doesn’t interfere with the team or center cards. Turning off unnecessary interactions keeps each card focused on its intended level. Finally, using measure-driven titles can make the layout more dynamic, such as showing the selected supervisor’s name automatically in the team section. Together, these steps will give you a clean and reliable setup for comparing teammate, team, and center performance in a single view.
Best Regards,
Tejaswi.
Community Support
