Returning customers based on the ID column

[ROG]

Hi guys,

How can I calculate the number of returning custmers based on the ID column?

If an ID appears more than once, it means they're return customer.

Thanks!!

[bhanu_gautam]

@ROG , You can achieve this using measure

returning_customers = COUNTROWS(FILTER(SUMMARIZE('Table', 'Table'[ID]), CALCULATE(DISTINCTCOUNT('Table'[ID])) > 1))

[ROG]

Thanks @bhanu_gautam 

Unfortunately, it's giving me blank. Any advice please?

Returning Users = COUNTROWS(FILTER(SUMMARIZE('Smart FAQ''s', 'Smart FAQ''s'[crm_id]), CALCULATE(DISTINCTCOUNT('Smart FAQ''s'[crm_id])) > 1))

% Returning Users = [Returning Users]/[No of users]

[bhanu_gautam · Accepted solution]

Sorry for this try using this it is working attaching PBIX file

Returning Customers = COUNTX(FILTER(SUMMARIZE('Table', 'Table'[CRM ID]), CALCULATE(COUNT('Table'[CRM ID])) > 1), 'Table'[CRM ID])

[rajendraongole1]

Hi @ROG - create a count of ids using calculated columns as below:

IDCount = COUNTX(FILTER('TableID', 'TableID'[ID] = EARLIER('TableID'[ID])), 'TableID'[ID])

create a measure to count the number of returning customers -IDs appearing more than once

Measure:

ReturningCustomers =
CALCULATE(
DISTINCTCOUNT('YourTable'[ID]),
'YourTable'[IDCount] > 1
)

Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!