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.

Follow this topic

Abdelrahman Mahmoud

Last answered:

18 Nov 2022

Posted on:

14 Nov 2022

in %TotalSalesAmount

in Power BI / Task Four, Part 3

2 answers ( 0 marked as helpful)

Kev Tomlinson

Posted on:

17 Nov 2022

Abdelrahman Mahmoud

Posted on:

18 Nov 2022

in %TotalSalesAmount

Submit an answer

related questions