Count the number of customers that ordered a certain product

[VitoMas]

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.

Thanks in advance!

[tangutoori]

proivde customers table info.

[v-piga-msft]

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

[Anonymous · Accepted solution]

@VitoMas 

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