Count with Filter, not reacting to filter

[cassidy]

Hello,

I have a list of products and the available inventory for each product on a specific day.  I simply want to count the product when the available inventory is > 0, but it returns the full count of products, no matter the qty.

I've done various forms of Counts, this is the current one:

In Stock Count = CALCULATE(COUNTX('Product Detail','Product Detail'[SKU]),Filter('Measures (Inventory BOW)',[Avail Status Units BOW (calc)] >0))

Small example of what it looks like.  It could be 500 units and Counts as 1 or 0 units and Counts as 1, the filter seems to have no impact.  The "Avail Status Units..." is a Measure that filters inventory to a specific date (beginning of the current week).:

[stevedep]

Use an IF statement?

InStockCount = 
var v_bow = CALCULATE(SUM('Table'[Avail Status BOW])) // your calculation
return
IF(v_bow>0;1;0)

[harshnathani · Accepted solution]

Hi @cassidy ,

Count Stock =
COUNTROWS (
FILTER ('Product Details',[Avail Status Units BOW (calc)] >0 )
)

Please share sample data if this does not work.

Regards,

HN

[cassidy]

@harshnathani , this seems to work!  Thanks

Are you able to easily explain why mine did not work?  I thought I was counting rows with the COUNTX.