Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
Please try something like:
In a table view, you'd probably need to make some tweaks to the measure
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |