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

Percentage of volume sold for each country out of each country's sales (not total)

Hello everyone,

 

I am trying to create a table where I could compare the performance of different countries in terms of sales. I have a list of countries and a list of different products and subproducts. My plan is to have a table with the following columns:

 

1- Subregion, where I would have the set of countries that are part of this subregion (A,B,C,...)

2- Percentage of sales of each subregion. Then I would filter for a product and would see the percentage that any product has in terms of the total revenue of each country. So, if I were to filter for product X, I would see that country A has 10% of its revenue coming from it, while B has 85%, C 30%...

 

I've been trying to use calculate(sum(Sales[Total])/calculate(sum(Sales[total],ALL(Sales[Subregion]), but that way I only get the % that each country represents in the subregion group, and if I filter for any product, I get the % that every country represents for any given product for that area group (always sum 1).

 

Can anyone help me figure out how to solve this? Smiley Happy 

 

Thanks

 

2 REPLIES 2
Super User
Super User

Re: Percentage of volume sold for each country out of each country's sales (not total)

Hey,

 

in the paragraph you describe the table you are looking for, but I have to admit that I do not understand where the product comes in to play that you want to use to filter your table.

 

Maybe it would be helpful to create a little pbix file with sample data, upload this file to onedrive or dropbox and share the link.

 

Regards

Tom

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
joasantos Frequent Visitor
Frequent Visitor

Re: Percentage of volume sold for each country out of each country's sales (not total)

Basically, I want to have a filter in the page for products and see the dependency that each country has for product X or Z. 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 274 members 2,904 guests
Please welcome our newest community members: