Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all, may I re-explain my request:
1. I have source table with diffirent value of three lists, revenue and profit like this:
2. With this data set, I can calculate profit margin of each row:
3. But if I choose, List 1: size L and M, List 2: color Blue and Green, I will have a combination, and bring profit margin = 92.41%:
4. Or if I choose diffirent: List 1: size L and M, List 2: color Blue and Green, List 3: type Coat and Skirt, they will bring profit margin = 97.86%
As you see, we can generate many diffirent combinations with these three lists, and each of them will bring another profit margin value. And the question is: What combination will bring to me the biggest profit margin value ?
The file here: https://drive.google.com/file/d/1uzQ1T7fhZZtzKQv9PkKtBfkUCHoxgvZx/view?usp=sharing
Many thanks for your help.
Solved! Go to Solution.
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:
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.
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:
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.
Hi all, may I re-explain my request:
1. I have source table with diffirent value of three list, revenue and profit like this:
2. With this data set, I can calculate profit margin of each raw:
3. If I choose, List 1: size L and M, List 2: color Blue and Green, I will have a combination, and bring profit margin = 92.41%:
4. If I choose diffirent: List 1: size L and M, List 2: color Blue and Green, List 3: type Coat and Skirt, they will bring profit margin = 97.86%
So, the question is: What combination will bring to me the biggest profit margin value ?
The file here: https://drive.google.com/file/d/1uzQ1T7fhZZtzKQv9PkKtBfkUCHoxgvZx/view?usp=sharing
Something along the lines of this?
Not quite, it seems. I hope the reult will look like this:
That's not going to be possible. You have to anticipate every possible permutation of attributes. Single, multiple and all values of list1 combined with any and all possible filtered values of list2, etc.
And ultimately, the other gentleman is right: the highest value for a single set of filters will always be higher than a mixed bag of them because incorporating other filters will always dilute that margin percentage.
@Greg_Deckler I saw your solution on a post, can you help me with this problem?
There's a DAX function for calculating the number of combinations in a set of data. So that shouldn't be awful to achieve. Getting the number associated with each combination a lot more difficult.
Thank all for your help. I'll try to explain my request on the picture below. I want to know what value I got with all combinations can be happen of my Category and Client. The combination can be result of one Category value and one Client value, or two Category value and one Client value, or three Category value and two Client value ...
@CongPham30SVN , Still not very clear. But you should provide slicer, so that users can select the value.
And you can display sum(Table[Normal Cus]) on a card visual
@CongPham30SVN ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
@CongPham30SVN not sure what output you are looking for? Can you provide more details on it?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |