Summarize Data based on each row of table

[DWilming]

Hi, 

I have a table with the following data: 

Customer, Country, Product, Netsales

With this origin a prepare a matrix which summarize all Netsales for Customer and Product.

|Country | Customer | Product | Netsales |

Now I want to add a measure which summarize all Netsales for each Product and Country. And show this value depending from the country of this customer in each row 

| Country | Customer | Product | Netsales | Netsales per Country |

Any Ideas?

[Greg_Deckler]

OK, so what do you have in your rows, columns and values for your matrix visual?

Some mocked-up data would really help along with the expected output of that sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[DWilming]

Ok, I hope this explains it better. So this is the visual except the last column. For this column I'm looking for a Measure example command, which generate the value based on the country and product column.

Country	Customer	Product	Net Sales	Net Sales Country
Albania	Customer A	ProductX	100	1465
Albania	Customer B	ProductY	123	123
Albania	Customer C	ProductX	132	1465
Romania	Customer A	ProductX	1233	1233
Romania	Customer B	Productxw	1222	1222
Romania	Customer C	Productyy	1444	1444
Germany	Customer A	ProductX	1223	2454
Germany	Customer B	ProductX	1231	2454
Germany	Customer C	Productxw	2321	2321
Germany	Customer A	Productyy	2322	2322

[Anonymous · Accepted solution]

sales per country =Calculate(sum(table[netsale]),allexcept(table,table[country],table[product]))

Thanks,
Pravin

If it resolves your problem mark it as a solution and give Kudos.