title: counting unique and duplicate values in multiple columns in powerbi
body: <p><a href="https://i.stack.imgur.com/PojFF.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PojFF.jpg" alt="Supervisor and Project Names"></a></p>
  
  <p>i have these values in a table in PowerBI
  What i need to do is to create a visualization showing the number of projects that a person shows up in,</p>
  
  <p>eg, alan is doing 2 projects and peter is doing 3, so there should be a no.of project by staff name kind of visualization.</p>
  
  <p>I tried merge tables, unpivot column but nothing works.</p>
  
  <p>Does anyone know how to do this? </p>