Jaron Wu
Last answered:

10 Dec 2020

 Posted on:

30 Nov 2020
0

Task 6, issue with last table of dashboard

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 ( 0 marked as helpful)
Dimitar Shutev
Instructor
Posted on:

06 Dec 2020
0
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
Jaron Wu
Posted on:

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

thanks
Dimitar Shutev
Instructor
Posted on:

10 Dec 2020
0
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

Submit an answer