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
Hi @CongPham30SVN ，
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.
Hi @CongPham30SVN ，
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?
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:
@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
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Click here to read more about the March 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.