Using Distinct Count on multiple columns

[JustSayJoe]

TableA contains:

• Email
• Product ID

Some emails only order 1 product, while others order multiple products.

I want to display a visual showing the various distinct counts of the Product ID column on the Y-Axis, and the distinct count of Emails on the X-Axis. Basically I want to show how many different Emails have ordered 1 product, 2 products, 3 products, etc.

How do I accomplish this?

[PhilipTreacy · Accepted solution]

Hi @JustSayJoe 

Download example PBIX file

In Power Query 

Starting with this data

Group the Email column using the Distnict Count of the Product column

Then group the Email column by the Distinct Count of the Email coumn

Plot that data, Number of Products needs to be on the x-axis

You can see that

1 product was bought by 1 email

4 products were bought by 2 emails

5 products were bought by 2 emails

7 products were bought by 1 email

Regards

Phil