Counting rows that have a value in a specific column

[nadim_dayoub]

I am trying to come up with an expression that would count how many items I sold based on if there is a value in a column and if the Lot matched. I and doing this through a virtual column.

So I thought this would be the expression:

COUNT(CONTAINS(ISNOTBLANK(Inventory[Job Name]), [Lot] = [_THISROW].[Lot]))

but I am getting “COUNT function is used incorrectly”