Resolved: One Measure for %Sales
Just curious,
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 😭
TIA Dimitar
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!