Forum Discussion

rosscortb's avatar
rosscortb
Post Patron
7 years ago
Solved

Count rows in a Table that have a specific value

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

    rosscortb Please try this as a "Measure"

     

    Measure = COUNTROWS(FILTER('DB Headcount','DB Headcount'[Payroll Area] <> "Babcock - Weekly"))
rosscortb's avatar
rosscortb
Post Patron
7 years ago

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's avatar
rosscortb
Post Patron
7 years ago
Any ideas?