Forum Discussion

cottrera's avatar
cottrera
Post Prodigy
6 years ago
Solved

Count based on multiple criteria DAX

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...
Need Help
  • AlB's avatar
    AlB
    6 years ago

    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  Datanaut

AlB's avatar
AlB
Community Champion
6 years ago

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  Datanaut