cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rosscortb Member
Member

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(COUNTROWS('DB Headcount'),ALLEXCEPT('DB Headcount','DB Headcount'[Payroll Area] = "Babcock - Weekly"))

 

Thanks


Ross

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Count rows in a Table that have a specific value

@rosscortb Please try this as a "Measure"

 

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


Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





3 REPLIES 3
Super User
Super User

Re: Count rows in a Table that have a specific value

@rosscortb Please try this as a "Measure"

 

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


Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





rosscortb Member
Member

Re: Count rows in a Table that have a specific value

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"))

Highlighted
rosscortb Member
Member

Re: Count rows in a Table that have a specific value

Any ideas?