The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Task 6, issue with last table of dashboard

Task 6, issue with last table of dashboard

0
Votes
3
Answer

Hi,
 
I am getting all 100% values of %sales, which means I’m using the same formula for the numerator and the denominator. Can you assist me as to why this is happening? 
I have posted screenshots of my file below.
 
Thank you for your help
 

3 Answers

365 Team
0
Votes

Hi Jaron,
 
Please provide the DAX for the other two formulas, from the current screenshot, the percentage formula looks ok, but I would like to see TotalSalesAmount and TotalSalesAmountAll
 
Kind Regards,
Dimitar Shutev

0
Votes

Hi Dimitar,
The code of the TotalSalesAmount and TotalSalesAmountAll are also attached in the previous post. 

thanks

365 Team
0
Votes

Hi Jaron,
 
I see what the problem is, what you need to do is to include the full code for AllCurrencies as the denominator, for example SalesAmountAll is a different filter context: which is why you are getting 100% across all of them. Please use

DIVIDE([TotalSalesAmount],CALCULATE(SUM(fact_InternetSales[SalesAmount]),ALL(dim_SalesTeritory[SalesTerritoryCountry])))*1

Thank you, you should include that in the videos.

1 month
JanuaryPromo
×
Complete Data Science Education
Get 50% OFF