The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to 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) )
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) )
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
8 | |
8 |