# in %TotalSalesAmount

How we divide the [TotalSalesAmount] / CALCULATE(SUM(fact_InternetSales[SalesAmount]),ALL(dim_SalesTeritory[SalesTerritoryCountry]),ALL(dim_SalesTeritory[CountryOrder]))

i thought we should change the divide to be CALCULATE(SUM(fact_InternetSales[SalesAmount]),ALL(dim_SalesTeritory[SalesTerritoryCountry]),ALL(dim_SalesTeritory[CountryOrder])) / [TotalSalesAmount]

i don't understand here the order of divide I think [TotalSalesAmount] is the large number and the other is the small number for each country

Hi Abdelrahman Mahmoud,

[TotalSalesAmount] is the TOTAL of all the countries if no filter applied, or when a country is 'selected' it then is the Total Sales for that country ONLY.

So its value can be the TOTAL of all countries when no filter (100%) or only part of the overall TOTAL when it filtered to the smaller number for each country.

The CALCULATE(SUM.....)) is a 'static' TOTAL SALES figure (not affected by Country filter selection), so in the formula it will always be the 'large' number.

So your understanding of the division format is correct - small above, large below - but the [TotalSalesAmount] is a 'changing' value, so its name may lead to some misunderstanding.

Hope the above makes sense.

Regards,

Kev T.

thanks i got it now