cancel
Showing results for
Search instead for
Did you mean:
Helper I

## Help about calculate the rate of combinations customer segment

Hi all,

I have an issuse and don't know how to slove it. I have a customer assembly, with Special Customer and Normal Customer. Each of them can be splited by four categories ( Category 1, Category 2, Category 3, Category 4 )

We can group two, three or four categories together, and we have n of combinations ( such as Cat 1 and Cat 2, Cat 1 and Cat 3, Cat 1 and Cat 2 and Cat 3....)

I want to know, what combination will bring max Rate value of Special Cus with Normal Cus. Please see the picture below:

Any one know how to handle it?

Many thanks, and sorry if I'm not good at English

6 REPLIES 6
Community Support

I doubt if it can be achieved in power bi automantically. In your sample in the new link, there are 3 values for each list. There are (3*2+1）*(3*2+1）*(3*2+1）-1 =342 combinations in your sample. If you want to get max value in all combinations, you need to list  all combination and calculate the value for it(even though there many blank value in these combination).

As far as I know, you can create new tables for all combinations in each list manually. and use crossjoin function to get all combinations for all list. But if you have many rows in each list, it will be a messy work. You need to list all combinations in each list manully.

Best Regards,

Dedmon Dai

Community Support

I'm not understanding with your expected output? Would you please explain more about it? Or you can show us some sample expected output by your data?

Best Regards,

Dedmon Dai

Helper I

Many thank for your help. Because yesterday I got some problem with my account, so I created a new post and describe more clearly ( I hope so ) about my request. Very hope you will have take a look:

https://community.powerbi.com/t5/Desktop/Need-help-with-all-combinations-can-be-happen/m-p/1575269#M...

Helper I
Super User IV

@CongPham30SVN , you can create formulas using those. Not very clear on what you need

refer how I used Switch on one and more column to get a new column

https://www.youtube.com/watch?v=gelJWktlR80

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Responsive Resident

Hello @CongPham30SVN

Would be better if you can share the pbix file or sample data with us

Regards

sanalytics

## Helpful resources

Announcements

#### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

#### Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

#### Claim Your Badge & Digital Swag!

Check out how to claim yours today!

#### Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors