Resolved: One Measure for %Sales

Question

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

Answer 1

The result is always 100%, even though I click on a particular currency. Can anyone explain to me why?

Answer 2

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.

Answer 3

Raja Ikhsan Halomoan

Posted on:

25 Apr 2023

0

Thanks a lot!

Resolved: One Measure for %Sales

Submit an answer

related questions