This project has moved. For the latest updates, please go here.

How to find Repeat Customer?

Nov 23, 2013 at 8:19 PM

I'm trying to figure out how to find "Unique Customer" who are classified as "Repeat Customer".

"Unique Customer" is correct: DISTINCTCOUNT(TableA[customer])

"Repeat Customer" Definition: Customers who have more than one records from distinct SalesDateID

Here's the DAX I have, but is not doing what I described above. It is returning the same value as Unique Customer. I logic is find the unique customer first, then use FILTER function to return customers who have distinct count of SalesDateID > 1. Let me know what could be wrong below? Or if you have better ways of constructing the DAX.


Your help is much appreciated.
Nov 26, 2013 at 5:23 PM
Anyone could help?