cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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
India20
China-15
Japan10
US20
Canada15
Russia-25
Congo-10
SouthAfrica25

 

Table2:

 

RegionCountry
ASIAIndia
ASIAChina
ASIAJapan
NACAUS
NACACanada
NACARussia
AfricaCongo
AfricaSouthAfrica

 

Output should be as below:

 

Region% Profit
ASIA5
     India20
     China-15
     Japan10
NACA3.333
     US20
     Canada15
     Russia-25
Africa7.5
     Congo-10
      SA25
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IX
Super User IX

Re: Average based on Groups

Sounds like a groups and supergroups issue:

 

https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Highlighted
Super User IX
Super User IX

Re: Average based on Groups

Sounds like a groups and supergroups issue:

 

https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Microsoft
Microsoft

Re: Average based on Groups

Hi @Dineshraj03,

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors