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?

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!

Follow this topic

Francois Chouinard

Last answered:

31 Dec 2022

Posted on:

31 Dec 2022

Total amount percentage always equals 100%

in Power BI / Final Project, Part 5

1 answers ( 0 marked as helpful)

Francois Chouinard

Posted on:

31 Dec 2022

Total amount percentage always equals 100%

Submit an answer

related questions