title: Power BI tabular report - Display rows that have duplicates across other rows within a group
body: <p>I am very new to Power BI and am finding my way around, and am struggling with this problem.</p>
  <p><a href="https://i.stack.imgur.com/HoJUk.png" rel="nofollow noreferrer">I have a dataset as below that has EMployee First Name , Last Name, Site , Employee ID.</a></p>
  <p><a href="https://i.stack.imgur.com/HcY2A.png" rel="nofollow noreferrer">I want to have a tablular listing of Employees with same First Name and Last Name, but within a Site  , so this data can be reviewed by the administrator to look out for possible duplicate data</a></p>
  <p>In SQL ,I would group the data by <strong>Site , EmpFName, EmpLName</strong> and display all rows where count(*) &gt; 1</p>
  <p><a href="https://i.stack.imgur.com/ETh7n.png" rel="nofollow noreferrer">Below is what I want to display in my Power Bi tabular report , the 4 rows where the same First Name, Last Name are found in a given site</a></p>
  <p>Also, my employee dataset is close to 500K rows .</p>
  <p>Any guidance would be very helpful.</p>
  <p>Regards,
  Sjrjej</p>