Percent of Teams Totals

[banksbc]

I have multiple employees in a employee table that shows what team they belong to.  I want to have a card on an employee dashboard that shows the percentage of tickets they have completed  based off the total tickets that team has completed.  The percentage will show on the card based off who is selected in the slicer.

Slicer will have each employees name from all teams

The [Employee Table] has more than just these two columns but is simplified for this post

The [Ticket Table] has the tickets assigned to each of the employees:

Desired result will be a card that shows the percentage of employee's tickets against their respective team's tickets based on whoever is selected in the slicer

Example:

If Bob is selected, the card will show 40%

If Larry is selected, the card will show 60%

etc.

[lbendlin]

Read about REMOVEFILTERS. Link the tables, then calculate the number of tickets for the selected employee, then count it again removing the employee filter. That will give you the ticket count for the team.