How to select the "DEPARTMENT" of a "User" that have more "Incidents - Resolved"

[Estebanco]

Hello guys,

If I have the following case:

If I have the following case:
How can I make a measure that shows in a table or card the "Department" that could solve more "Incidents"?

Table 1

Users	Department
Luis	1
Sandra	2
Miguel	3
Ana	4

Table 2

Users	Incidents
Ana	Resolved
Sandra	In Progress
Ana	In Progress
Miguel	Resolved
Luis	Resolved
Ana	In Progress
Ana	Resolved
Ana	Resolved
Sandra	Resolved

Thanks in advance

[BA_Pete · Accepted solution]

Hi @Estebanco ,

The basic measure would be something like this:

_noofIncidentsResolved =
CALCULATE(
    COUNTROWS(Table2),
    Table2[Incidents] = "Resolved"
)

To calculate this by department, you will need to relate Table1 to Table2 on [Users], then put Table1[Department] and [_noofIncidentsResolved] into a visual together.

Pete