Time-specific values are counted in an array table

I have a data table that shows the performance of hundreds of vendors in 4 categories each month. The provider can have multiple rows for the same month, so I want to summarize the total results for each month, create a measure based on the total values, and then count if that measure is <-85.

I added a column to my data table to say "if <-85, assign "Low Performance", but this assigns "Low Performance" for each row..... However, that provider can have poor performance for rows 1 and 2, and the high throughput for row 3 and currently have a total sum that results in high performance for the month.

I have an array table that shows the total performance of the providers throughout each month. The performance values shown are a measurement calculation of the 4 category measures.

The result of the matrix looks like this. I want to count (on a new table or card) the number of times each Provider has a score of 85 or less over the months and the total number of red counts within a month.

• In this example, Vendor 1 must result in 3, Vendor 2 must be 4, Vendor 3 is 1, Vendor 4 is 6.
• March must be a count of 4.

I hope any of this makes sense :). Thank you!