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”