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)
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
Resolved: the total sales amount for USA comes as 9M not 9.39M as in the video so can you please advise?!