Count rows in a Table that have a specific value

[rosscortb]

Hello

I am tring to count the headcount rows but I don't want the value " Babcock - Weekly" that is in column DB Headcount[Payroll Area]

I have

Headcount minus Babcock Weekly = CALCULATE(COUNTROWS('DB Headcount'),ALLEXCEPT('DB Headcount','DB Headcount'[Payroll Area] = "Babcock - Weekly"))

Thanks

Ross

[PattemManohar · Accepted solution]

@rosscortb Please try this as a "Measure"

Measure = COUNTROWS(FILTER('DB Headcount','DB Headcount'[Payroll Area] <> "Babcock - Weekly"))

[rosscortb]

Thank you for that, is there anyway i can also add a month filter to the below?  FILTER('Month', 'Month'[Month]

Headcount minus Babcock Weekly = COUNTROWS(FILTER('DB Headcount','DB Headcount'[Payroll Area] <> "Babcock - Weekly"))

[rosscortb]

Any ideas?