Last answered:

05 Jul 2021

Posted on:

04 Jul 2021

0

Task 6 - Sales Amount Percentage

image
Based on the screenshot, the sale amount% don't reflect the right amount. I use the same formula as the video. However, I suspect it could be related to the interaction part. Need help in determining the right visual to edit the interaction.

3 answers ( 0 marked as helpful)
Posted on:

05 Jul 2021

0

Can you please provide the DAX for the two measures that you are using?

Posted on:

05 Jul 2021

0

Here are the DAX:
TotalSalesAmountV2 = CALCULATE(SUM(fact_InternetSales[SalesAmount]))
TotalSalesAmountALL = CALCULATE([TotalSalesAmount], ALL(dim_Currency))

Posted on:

05 Jul 2021

2

Hi Mr Dimitar, I found the main cause of the problem already. It's because the filter is applied to currency. Instead, the calculation DAX should have filter for country.

Submit an answer