Calculate Products by Consumer and classify Consumers.

[Anonymous]

Hi, I'm a newby in PowerBI and I have a task to solve.

I have 2 Tables joined by Consumer ID

Table A contains Order Data
Table B contains Product Details (product list assigned to the consumer)

The first step is to calculate how many products are assigned to each consumer (and show zero if the consumer has no products assigned) 
Second step is to classify the consumers in X and Y based on the quantity of Products assigned (ex. if consumer has more than 1 product assigned then it is considered X, else it is considered Y) 

Can anyone suggest a solution for me?

It would be much appreciated.

[Anonymous]

Thanks

[v-diye-msft]

Hi @Anonymous 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[amitchandak · Accepted solution]

@Anonymous , refer if this can help you

SEGMENTATION

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization