title: count rows with duplicate values and group by multiple columns using PowerBI DAX
body: <p>Dose anyone know how to count rows with duplicate values and group by multiple columns using PowerBI DAX? Below is the example, how to generate the row count by name and group? Thank you in advanced.</p>
  <p>Data source table1:</p>
  <p><a href="https://i.stack.imgur.com/yGBcX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yGBcX.png" alt="enter image description here" /></a></p>
  <p>Expected table:</p>
  <p><a href="https://i.stack.imgur.com/SZ63X.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SZ63X.png" alt="enter image description here" /></a></p>