Forum Discussion

rosscortb's avatar
rosscortb
Icon for Post Patron rankPost 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"))
PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
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
    Icon for Post Patron rankPost 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
      Icon for Post Patron rankPost Patron
      7 years ago
      Any ideas?