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
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
The code of the TotalSalesAmount and TotalSalesAmountAll are also attached in the previous post.
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
Thank you, you should include that in the videos.