How to find the No. of Second Purchases through DAX

[Anonymous]

Hi Everyone,

I need to find the count of customers who did second purchases. This is defined as the count of users who have placed more than one order.

Could someone help me with DAX logic?

[johnt75 · Accepted solution]

You could try a measure like

Num customers > 1 order =
var summaryTable = ADDCOLUMNS( VALUES( Orders[Customer ID]), "@num rows", CALCULATE(COUNTROWS(Orders)))
return COUNTROWS( FILTER( summaryTable, [@num rows] > 1) )