Task 6 - Sales Amount Percentage
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)
Can you please provide the DAX for the two measures that you are using?
Here are the DAX:
TotalSalesAmountV2 = CALCULATE(SUM(fact_InternetSales[SalesAmount]))
TotalSalesAmountALL = CALCULATE([TotalSalesAmount], ALL(dim_Currency))
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.