Count Number of Values in a Matrix

[mikeoshields]

Dax question.  Below is a matrix of results and the rows/columns/values in the PowerBI project.  I need to count the number of values that are less than zero (see below).  

What I'm looking for is something like this:

Any ideas would be appreciated.

[amitchandak]

@mikeoshields , Try measure like

countrows(summarize(Table[productCD], Table[Qtyonhand], Table[Date].Year, Table[Date].month))

or

countrows(summarize(Table[productCD], Table[Date].Year, Table[Date].month))

[mikeoshields]

Thanks but that did not give me what I need.  I'd be happy to upload an excel file with the raw data as well as the PowerBI file but there doesn't seem to be a way to do that!

[mikeoshields]

I've included a link to the .pbix file as well as an excel spreadsheet of the raw data.  Again, any help is appreciated.

Count Number of Values in a Matrix