Count how many people placed multiple orders on the same day

[Greenterer]

I have a table with data for customer name, product ordered, and ordered date.  I'm trying to figure out how to identify and count how many customers bought multiple products on the same day.

Orders

Name     Product Ordered    Order Date

Joe          A                            3/1/2024

Joe          B                             3/1/2024

Bob         A                             3/1/2024

Bob         B                             3/2/204

I'd want to know that one customer, Joe, ordered both products on the same day.  

[Anonymous · Accepted solution]

Hi @Greenterer 

First, you can create a table using the following DAX.

Table 3 = SUMMARIZE('Table','Table'[Name],'Table'[Order Date],"ProductCount",DISTINCTCOUNT('Table'[Product Ordered]))

Then you can use the following DAX to get the results you want.

Measure2 = CALCULATE(COUNTROWS('Table 3'),FILTER('Table 3',[ProductCount]>1))

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vicky_]

Please try something like:

Multiple Products Same Day = INT(CALCULATE(COUNTROWS(Orders), REMOVEFILTERS(Orders[Product])) > 1)

In a table view, you'd probably need to make some tweaks to the measure