Resolved: One Measure for %Sales
you created three different measures to achieve %Sales. Can I make one measure and place those other measures in "variables"?
Sorry my English is not good 😭
3 answers ( 1 marked as helpful)
The result is always 100%, even though I click on a particular currency. Can anyone explain to me why?
Please change your variable to include SUM(fact_InternetSales[SalesAmount] instead of calling out the TotalSalesAmount variable. You are getting 100% because what happens is the TotalSalesAmount variable gets filtered by the currency slicer and the value gets passed down to the TotalSalesAmountAll variable therefore you are getting the same number for nominator and denominator resulting in 100% all the time.
Thanks a lot!
Submit an answer
Resolved: the total sales amount for USA comes as 9M not 9.39M as in the video so can you please advise?!