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”

[Marc_Dillon]

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[nadim_dayoub]

That is what I tried at first, but I got “SELECT has invalid inputs”

This is what I tried before trying CONTAINS()

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

Maybe I am trying too much or can’t wrap my simple brain around it.

[Marc_Dillon · Accepted solution]

[nadim_dayoub]

Thank you for saving me once again!