How to summarize by calculated measure in Power BI?
<p>I have transactional data which contains customer information as well as stores they shopped from. I can count the number of different stores each customer used by a simple <code>DISTINCTCOUNT([Site Name])</code> measure. </p>

<p>There are millions of customers and I want to make a simple summary table which shows the sum of # customers who visited X number of stores. Like a histogram. Maximum stores they visited is 6, minimum is 1.</p>

<p>I know there are multiple ways to do this but I am new to DAX and can't do what I think yet.</p>