Count based on multiple criteria DAX

[cottrera]

Hi I have a tAble called 'Job Schedue' with two columns. I need to perform a DAX countif function that counts the following

Count if Team = 'Sub Contractor' and Job Status = 'AWIAITING SCHEDULING' and ' = SCHEDUED'

Thank you

Table name -  Jobs Schedule
Job Status	Team
Awaiting Scheduling	Sub Contractor
On Hold	DLO
Scheduled	DLO
Completed	Sub Contractor
Completed	Sub Contractor
Awaiting Scheduling	Sub Contractor
Awaiting Scheduling	DLO
Awaiting Scheduling	Sub Contractor
Completed	DLO
Awaiting Scheduling	Sub Contractor
Scheduled	Sub Contractor
Completed	DLO
On Hold	Sub Contractor
Scheduled	Sub Contractor
Scheduled	Sub Contractor
Expected result	6

[AlB · Accepted solution]

Hi @cottrera 

Place this measure in a card visual:

Measure =
CALCULATE (
    COUNT ( Table1[Team] ),
    Table1[Team] = "Sub Contractor",
    Table1[Job Status] IN { "Awaiting Scheduling", "Scheduled" }
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers