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|
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|
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!
Solved! Go to Solution.
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.