Last answered:

31 Dec 2022

Posted on:

31 Dec 2022

0

Total amount percentage always equals 100%

For some reason, my division always return 100%. Not sure what I am doing wrong here:

TotalSalesAmount = SUM(fact_InternetSales[SalesAmount])
TotalSalesAmountALL = CALCULATE([TotalSalesAmount], ALL(dim_Currency))
%Sales = DIVIDE([TotalSalesAmount],[TotalSalesAmountALL])*100

and yet, all my Sales % equals 100%.   Any idea on what I am doing wrong?   

1 answers ( 0 marked as helpful)
Posted on:

31 Dec 2022

0

Oh I got It. My TotalSalesAmountALL is based on the currency, not the country.
I add the measure
TotalSalesAmountALLCountry = CALCULATE([TotalSalesAmount]ALL(dim_SalesTeritory[SalesTerritoryCountry]))

then I change %Sales to:
%Sales = DIVIDE([TotalSalesAmountV2],[TotalSalesAmountALLCountry])*100

Now, that is working!

Submit an answer