cancel
Showing results for
Did you mean:
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?

Thanks

2 REPLIES 2
Highlighted
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
Proud to be a Datanaut!
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.

Announcements

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 121 members 1,555 guests
Recent signins: