orders

2 Topics

Calculate Customers with more than one order of X product
Hello masters, I wish to create a measure which calculates the number of customers who REPURCHASED a product = bought X product in more than 1 different orders (in a dynamic range of dates). Please note that a repurchase occures when a product is purchased by a specific customer in more than 1 order (2/3/4.....). it actually counts the customers who bought x product in more than 1 and above order IDs. Below example of data and the desired measure result: Date Order ID Customer ID Product 01/01/2022 AAA 111 x 01/01/2022 AAA 111 y 03/01/2022 BBB 111 x 04/01/2022 CCC 222 y In this range of dates - product x was repurchased by 1 customer (111) , product y was not repurchased by any customer. thanks in advance champs, Amit
Solved
akfir
4 years ago Place DAX Commands and Tips
6KViews
0likes
13Comments
First time orders in a given period
We would like to make a DAX measure that shows users that have had their first order in a period. I tried using: FirstInteractionDate = CALCULATE(MIN(orders[created_date]),DATESBETWEEN('Date'[Date],MINX(all('Calendar'),'Calendar'[Date]),MAX('Calendar'[Date]))) and New Customers = COUNTROWS(FILTER(VALUES(orders[customer.id]),[FirstInteractionDate] >= MIN('Calendar'[Date]))) to try and calculate it, but it shows the active users, which are measured with this: ordered_user_count = CALCULATE(DISTINCTCOUNT(orders[customer.id]), FILTER(orders, orders[order_count_per_customer] > 0))+0 with the order_count_per_customer being: order_count_per_customer = CALCULATE(COUNTROWS(orders),FILTER(orders,orders[customer.id]=EARLIER(orders[customer.id]))) How would I calculate the first order users in a given period of time? Thanks
Kareem_Amr_IT
4 years ago Place DAX Commands and Tips
641Views
0likes
1Comment