topic Returning customers based on the ID column in DAX Commands and Tips

Returning customers based on the ID column

ROG — Fri, 21 Jun 2024 10:21:53 GMT

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 — Fri, 21 Jun 2024 10:29:17 GMT

ROG , You can achieve this using measure

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

rajendraongole1 — Fri, 21 Jun 2024 10:30:39 GMT

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!!

ROG — Fri, 21 Jun 2024 11:28:47 GMT

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 — Fri, 21 Jun 2024 12:41:55 GMT

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])