Forum Discussion
Average based on Groups
Please help with the solution for below
I need to group the profit % for each and every country based on the respective regions.
Below are the example:
Profit % is a measure calculated in report.
Inputs:
Table 1
| Country | % Profit |
| India | 20 |
| China | -15 |
| Japan | 10 |
| US | 20 |
| Canada | 15 |
| Russia | -25 |
| Congo | -10 |
| SouthAfrica | 25 |
Table2:
| Region | Country |
| ASIA | India |
| ASIA | China |
| ASIA | Japan |
| NACA | US |
| NACA | Canada |
| NACA | Russia |
| Africa | Congo |
| Africa | SouthAfrica |
Output should be as below:
| Region | % Profit |
| ASIA | 5 |
| India | 20 |
| China | -15 |
| Japan | 10 |
| NACA | 3.333 |
| US | 20 |
| Canada | 15 |
| Russia | -25 |
| Africa | 7.5 |
| Congo | -10 |
| SA | 25 |
Sounds like a groups and supergroups issue:
https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
2 Replies
Sounds like a groups and supergroups issue:
https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
Hi Anonymous,
The Greg_Deckler shared the detailed solution in the link, please mark the helpful reply as answer, so we can close this case and more people will learn new things from here.
Best Regards,
Angelia
