Calculating the number of inspections completed by an individual

[BeardedCreeker]

I have two tables. One contains data related to inspections completed such as the Primary inspector, date, inspection number, and some other data that does not matter in this case. I need to count the inspections completed but I only want to count the ones that were completed by senior leaders in the organization. My second table contains 2 columns which lists the senior leaders, with their name in one column and their department in the other.

I had previously counted them using the following and then in the visual I filtered using the list of leaders and the relationship as a means to accomplishing my count, however i want to also display the inspections by leaders and another column showing inspections by non-leaders and that method of filtering won't work anymore.

Inspections = CALCULATE(

COUNT('Inspections'[Inspection ID]),

FILTER(ALLSELECTED('Dates'), 'Dates'[Date] <= Max('Dates'[Date])))

Inspections Table

Inspection ID	Primary Inspector	Date	Office	Region
1234	Fred K	02-10-2021	Edmonton	Northern Alberta
2345	Mike G	03-02-2021	Calgary	Southern Alberta
3456	Sheala K	03-15-2021	Guelph	Ontario
4567	Steph R	04-10-2021	Fort St. John	British Columbia

Leaders Table

Leader	Department
Fred K	Manufacturing
Mike G	Purchasing
Steph R	Warehouse
Frank L	Office Services

Any help would be greatly apreciated. This seems like it should be fairly easy but I cant get it to work for the life of me.

[Fowmy · Accepted solution]

@BeardedCreeker 

To get the leaders count:

leaders count = 
COUNTROWS(
    FILTER(
        SUMMARIZE(Inspections,Inspections[Inspection ID],Inspections[Primary Inspector]),
        Inspections[Primary Inspector] in VALUES(Leaders[Leader])
    ) 
)    

Non Leaders Count:

Non leaders count = 
COUNTROWS(
    FILTER(
        SUMMARIZE(Inspections,Inspections[Inspection ID],Inspections[Primary Inspector]),
        NOT Inspections[Primary Inspector] in VALUES(Leaders[Leader])
    ) 
)