title: Group 10 columns of data to gain distinct count of rows Power BI
body: <p>I'm trying to display all of the distinct values within this table (there are many other columns in this table) and show how many rows each distinct value shows in.</p>
  <p>I have tried to use group by but this does not work. It needs to be filterable by country from another column but i can do that by page filter.</p>
  <p>I am trying to show what the top 5 associations are in terms of appearance.</p>
  <p><a href="https://i.stack.imgur.com/MILEn.png" rel="nofollow noreferrer">enter image description here</a></p>