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.
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 |
Solved! Go to Solution.
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
Sounds like a groups and supergroups issue:
https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |