I couldn't really understand why we used ALL function with the dim_SalesTerritory[CountryOrder] country order in the calculation of the dominator for the percentage of total sales amount measure, could you please explain it further

During the time of the recording we were having issues with the results for each country when we ordered the sorting to be based off Country Order. Having the ALL function applied on CountryOrder is no longer necessary, instead a better practice would be to say ALL(dim_SalesTeritory) so that the ALL operator will be applied on the entire country table.

%TotalSalesAmount = DIVIDE( [TotalSalesAmount] , CALCULATE(SUM(fact_InternetSales[SalesAmount]), ALL(dim_SalesTeritory[SalesTerritoryCountry]), ALL(dim_SalesTeritory[CountryOrder])))*100 i meant , why you used country order column and didn't only use SalesTerritoryCountry ?

Follow this topic

Toka Saad

Last answered:

10 Jan 2023

Posted on:

08 Jan 2023

Resolved: % total sales amount measure

in Power BI / Task Four, Part 3

3 answers ( 2 marked as helpful)

Dimitar Shutev

Instructor

Posted on:

08 Jan 2023

Helpful answer

Toka Saad

Posted on:

09 Jan 2023

Dimitar Shutev

Instructor

Posted on:

10 Jan 2023

Helpful answer

Resolved: % total sales amount measure

Submit an answer

related questions