Need list of customers with more than 1 purchase

[cnpdx]

I am trying to get a LIST of customers who had more than 1 purchase.

Below, you can see each customer has a unique code, so there are more jobs than distinct codes, as there are a few repeat customers. 

I was able to get the AGGREGATE data to show # of repeat customers, as you can see from this table. But when I try to add a row dimension to the table for customer name, it will not show the 30 customers who have more than 1 job. 

So, how do I get a table, with a list of customers specifically who had more than 1 job, to match the aggregate value already presented? thanks!

Distinct Count of Customer Jobs = CALCULATE(DISTINCTCOUNT('SALES DETAILS'[Sales Customer Job])

Distinct Count of Customer Code = CALCULATE(DISTINCTCOUNT('SALES DETAILS'[Sales Customer Code])

Customer with more than 1 job = [Distinct Count of Customer Jobs]-[Distinct Count of Customer Code]

[Phil_Seamark]

Are you looking for a monthly list of customers with more than one job?  Or just over all time?

[cnpdx]

thank you @Phil_Seamark

it has to be time sensitive. For example, the company is SaaS, customers are recurring monthly, so we are looking for customers within a given month who had more than one TRANSACTION. We can't count products, because there can be more than 1 product on an invoice and that's ok. So we are looking for customers in one month who had more than one TRANSACTION (aka more than one invoice).

[v-qiuyu-msft]

Hi @cnpdx,

You can create a summarized table like below:

Table 2 = SUMMARIZE('Table5','Table5'[Year],'Table5'[Month],'Table5'[Customers],"CountInvo",COUNTA('Table5'[Invoices]))

Then drag values from the customer to the table visual, set Visual Level filter based on "CountInvo" is greater than 1. See:

Best Regards,
Qiuyun Yu

[danrmcallister]

@cnpdx: how about this:

• In your original data table, add a column that counts the # of sales made to any particular customer.  This will allow you to identify your repeat customers
• Create a new "repeat customers" table that filters out any customers that are not repeat customers

Code to count individual sales per customer as a new calculated column:

#Sales = CALCULATE(
    COUNTROWS(Data),
    FILTER(Data,
        Data[Customer] = EARLIER(Data[Customer])
    )
)

Code to create a table that only includes repeat customers:

RepeatCustomers = DISTINCT(
    CALCULATETABLE(
        Data,
        Data[#Sales]>1
    )
)

Does this match what you're trying to do?  Here are some screenshots if those help.

Dan