Help with combinations by DAX

Hi, CongPham30SVN 

According to your description, I can clearly understand what you want to get.

You said you want to get the combination that will bring you the biggest profit margin value, I think there are many possible combinations. My opinion is that the best way is to experiment with all the possible ways to get the final result. You can take a look at my steps and find if it’s useful:

1. I create three Matrix to get the rank of the profit margin of the three categories in order to make the combination:

2. Then I can make the permutation and combination according to the large selections:

• One List1, one List2：96.43%

• Two List1, one List2: 96.43%

• Two List1, two List2: 95.71%

• One List1, two List2：94.55%

• Two List1, three List2: 93.00%

As we can see, when you select “M”, “Blue”, you can get the the biggest profit margin value, which can prove also prove the truth that littlemojopuppy posted: Single filter is always greater than multiple filter.

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.