Count # of Times Specific Values Show up in a Matrix Table

[ecardoso626]

I have a data table that shows the performance of hundreds of suppliers across 4 categories each month. The supplier can have multiple rows for the same month, so I want to sum up the total results for each month, create a measure based on the total values, then do a 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 supplier can be low performing for rows 1 & 2, and high performing for row 3 and actualy have a total summation that results in high performance for the month. 

I have a matrix table that shows the total performance of suppliers across each month. The performance values shown is a measure calculation of the 4 category measures.

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

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

Hope some of this makes sense :). Thanks!

[amitchandak]

@ecardoso626 , You can try like

countx(Filter(Summarize(Table, Table[Supplier], Table[month],"_sc",[score]),[_sc]<=.85),[supplier])

You can replace with respective dimension member if needed