Last answered:

18 Nov 2022

Posted on:

14 Nov 2022

0

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

2 answers ( 0 marked as helpful)
Posted on:

17 Nov 2022

3

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.

Posted on:

18 Nov 2022

0

thanks i got it now

Submit an answer