cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

Count the number of customers that ordered a certain product

I would like to know the amount of customers ordered a certain product or product category.

This is the table i got now.

 Product Category Sales Margin Order Quantity Accessories 1.272.057 938.849 61.931 Bikes 94.620.526 55.769.115 90.220 Clothing 2.117.614 1.619.742 73.598 Components 11.799.076 7.509.942 49.027 Total 109.809.274 65.837.650 274.776

I would like to perform this measure with DAX and i got the product category id, subcategory id and a customer id to work with.

The desired output would be something like this.

 Product Category Sales Margin Order Quantity #Customers that bought this product Accessories 1.272.057 938.849 61.931 147 Bikes 94.620.526 55.769.115 90.220 785 Clothing 2.117.614 1.619.742 73.598 54 Components 11.799.076 7.509.942 49.027 258 Total 109.809.274 65.837.650 274.776 1244

If you need any more information feel free to ask me. I'm a beginner in DAX so i could be forgetting some crucial things.

1 ACCEPTED SOLUTION

Accepted Solutions
Member

Re: Count the number of customers that ordered a certain product

Would bringing the customer ID to ur table and changing it as a count help for this?

3 REPLIES 3
Member

Re: Count the number of customers that ordered a certain product

Would bringing the customer ID to ur table and changing it as a count help for this?

Community Support Team

Re: Count the number of customers that ordered a certain product

Hi @VitoMas,

Have you solved your problem based on the suggestion of Akshaya?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your data sample of Customer so that I could understand your scenario better and help further on it.

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

Re: Count the number of customers that ordered a certain product

proivde customers table info.