title: How to do countifs in powerbi
body: <p>I want to do countif in PowerBI (Example: count of total item with condition #1: having transaction of 2 or more, condition #2: year)</p>
  
  <p>I have sample data comprised of PO (transaction) #, item #, date (year), item description, ship to location. </p>
  
  <p>I can achieve the result through Excel - Pivot a matrix table of rows of items, columns of year and the value is count of PO/transactions. A separate table on the side is utilized to count the total item within Column (Years) that has transaction count > 2. </p>
  
  <p>I can't figure out what DAX to use in PowerBI to achieve the same thing as I could with Excel:</p>
  
  <p><a href="https://i.stack.imgur.com/eYqp9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eYqp9.png" alt="enter image description here"></a></p>
  
  <p>Sample of transaction counts: </p>
  
  <p><a href="https://i.stack.imgur.com/YxY6N.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YxY6N.png" alt="enter image description here"></a></p>