Forum Discussion
count duplicate dates per Customer ID
- 5 years ago
Hi Laufer_Israel ,
Based on your description, you can create this measrue to count:
Count = VAR tab = FILTER ( ALL ( 'Table' ), CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( ALL ( 'Table' ), 'Table'[ID] = EARLIER ( 'Table'[ID] ) && 'Table'[Date] = EARLIER ( 'Table'[Date] ) ) ) >= 2 ) RETURN COUNTX ( FILTER ( tab, [ID] IN DISTINCT ( 'Table'[ID] ) && [Date] IN DISTINCT ( 'Table'[Date] ) && [Order Type] = "regular" ), [Order Type] )Attached a sample file in the below, hopes to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I will try to be more clear:
Regular order means that the customer ordered stock directly from the sales man in a specific day. a Digital order is an order that the customer conducted in advance (for a specific date).
When I see in the data two orders for the same day when one is regular and the other is digital it means that the digital order wasn't anoght for the customer and he asked the sales man for an immidiate additional order.
Thats what I'm looking for - I'm trying to understand how many regular orders apears at the same day of the digital order.