title: Power BI : How to count occurrence of value from source table?
body: <p>I have my data source something like below.</p>
  
  <p><a href="https://i.stack.imgur.com/BoYTq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BoYTq.png" alt="enter image description here"></a></p>
  
  <p>I need to show output in the report as below.</p>
  
  <p><a href="https://i.stack.imgur.com/sEShA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sEShA.png" alt="enter image description here"></a></p>
  
  <p>I tried using the unpivot column and getting something like this, how to count the occurrence value of each Business value.</p>
  
  <p><a href="https://i.stack.imgur.com/WVRaA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WVRaA.png" alt="enter image description here"></a></p>