Forum Discussion
COUNT IF MULTIPLE CONDITIONS
Hello
I need to get the distribution of customers based on the products they buy. To contemplate that I have a capated customer, they must have purchased certain products from different categories. For example:
| CAT. PRODUCT | 00 | 00 | 01 | 01 | 01 | 02 |
| PRODUCT | 1 | 2 | 3 | 4 | 5 | 6 |
| A | X | X | X | |||
| B | X | X | X | X | ||
| C | X | X | X | X | ||
| D | X | X | X | X | X |
In this case, the distribution of product category 00 would be 2 customers, because only customer A and customer D have purchased the two products in the category.
The distribution of category 01 would be 1 customer, because only customer C has purchased all 3 products.
And the distribution of category 02 would be 3 customers (A, B and D).
I thought I could do it with a conditional, but I need a lot of conditions. Is there a way to do this count in PowerBi?
Thank you
1 Reply
Hi Syndicate_Admin ,
In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
