title: How do I count the number of occurrences that a value in a Power BI matrix > X
body: <p>I am trying to create a measure that counts the number of occurrences where any employee worked in excess of 45 hours in any week. I've looked at other posted questions and can't seem to connect the dots to my specific question. The following matrix shows the total hours worked by employee by week:</p>
  <ul>
  <li>Employees and Hours (the rows and values in the matrix, respectively) reside in the same table called &quot;Power BI Upload&quot;</li>
  <li>Week Number (Columns in the matrix) reside in a separate table called &quot;Date Table&quot;</li>
  </ul>
  <p><a href="https://i.stack.imgur.com/lflTB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lflTB.png" alt="Weekly Hours by Employee" /></a></p>
  <p>My desired total row would show:</p>
  <ul>
  <li>Week 30 has 2 total occurrences (50 and 48)</li>
  <li>Week 31 has 3 total occurrences (60, 54, 47)</li>
  <li>Week 32 has 3 total occurrences (48, 47, 47)</li>
  <li>Week 33 has 5 total occurrences (46, 47, 72, 64, 68)</li>
  <li>Week 34 has 5 total occurrences (48, 55, 56, 67, 62)</li>
  </ul>
  <p>I hope I am being clear. Thank you very much for your help.</p>