Need to create a count measure that excludes one specific text string.

[NCato]

My scenario is that I have warehousing picking data that picks up a worker ID if our employees use a handheld RF device to do the work.  The column contains 8 digit worker ID's, and for any that didn't utilize the RF device, it reads "Manually Picked".

I was trying something like this, but I don't know the syntax for the NOT argument.  Or, if anyone has  amore elegant solution, I'm all ears.

RF Device Line Count =

CALCULATE (

     COUNT(PBI_PickingJourLines[WORKERID]),

     NOT PBI_PickingJourLines[WORKERID] "Manually Picked"

)

[CoreyP · Accepted solution]

Try replacing not with "does not equal" so,

RF Device Line Count =

CALCULATE (

     COUNT(PBI_PickingJourLines[WORKERID]),

     PBI_PickingJourLines[WORKERID] <> "Manually Picked"

)

[NCato]

I'm getting this error and a broken visual.  Do I need to lean on one of the other COUNT types?

[CoreyP]

try using COUNTROWS instead

[NCato]

I tried COUNTA, and it worked.  What's the benefit of using COUNTROWS?

[CoreyP]

I'm not smart enough to know that. If it works, I use it. Haha. Maybe once I learn more.

[CoreyP]

Actually...I just looked into it.

COUNTA counts number of values in a column, COUNTROWS counts the number of rows in a table. So, if your table had blanks, COUNTA would not include them, whereas COUNTROWS would.