Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
84 | |
77 | |
66 |
User | Count |
---|---|
135 | |
109 | |
104 | |
83 | |
73 |