Resolved: Power BI Final Project part 13
Dear Mr. With Dimitar Shutev,
All entries of %Sales show 100.00.
Please tell why it happens like that.
Amy Soe
can you please provide your DAX code?
DAX code for %Sales is:
%Sales = DIVIDE([TotalSalesAmount],[TotalSalesAmountAll])*100
DAX code for %Sales is:
%Sales = DIVIDE([TotalSalesAmount],[TotalSalesAmountAll])*100
ok, and what is inside TotalSalesAmountAll? Can you please share that as well?
TotalSalesAmountAll = CALCULATE([TotalSalesAmount],ALL(dim_Currency))
Please try replacing dim_Currency with country inside the ALL function
OK. I try replacing with country inside ALL function like ...
TotalSalesAmountAll = CALCULATE([TotalSalesAmount],ALL(dim_SalesTeritory))
Now, it works fine.
Please see my attached screenshot.
Thank you so much.
The whole course explanation are really helpful for us.
