Trying to Count Number of Cells filtered on Another Column

[delt127]

Table Name = Training Status
Column #1 = Category
Column #2 = Expiration Date

I would like to count all the cells in the "Expiration Date" greater than a certain date (30 September 2019) and only if the "Category" = First Aid.

Here is the DAX formula I have but is giving me an error:

=CALCULATE(COUNTX(Training_Status, Training_Status[Expiration Date]>DATE(2019,9,30), Training_Status[Category]="First Aid")

Can you help me figure out the error?

Thanks!

 

[VBA Geek]

I assume you're just looking for this:

=CALCULATE(
    COUNTROWS(TrainingStatus),
    TrainingStatus[Expiration Date] > DATE(2019,9,30),
    TrainingStatus[Category] = "First Aid")