Forum Discussion

MHongisto's avatar
MHongisto
Frequent Visitor
9 years ago
Solved

Quick measure - Percentage difference

If I want to calculate percentage of costs vs sales amounts, I tried using the quick measure percentage difference. It gave me this code:   Measure1 % difference from Sales amount = VAR __BASELINE...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi MHongisto,

     

    "Percentage difference" is under the submenu "Mathematical operations". It looks like a math theory, which evaluates the difference and compare with the base value. Please refer to Percent of Increase or Decrease if you'd like to.

     

    Best Regards!

    Dale

cs_skit's avatar
cs_skit
Resolver IV
9 years ago

Percentage type just displays 0.7 or 1.5 as 70 % or 150%

 

So DIVIDE(Sales;Base) is correct if your sales are 1500 and your base is 1000 result is 1.5 so displayed as 150% when you change it to Percentage

MHongisto's avatar
MHongisto
Frequent Visitor
9 years ago

The Quick measure - Percentage difference calculation automatically puts the subtraction in DIVIDE. I don't understand why. Bug or feature?

  • cs_skit's avatar
    cs_skit
    Resolver IV
    9 years ago

    Its a Percentage DIFFERENCE

    Its just a recommendation.

    It makes sense in many scenarios like:

     

    Base 1000 Value 1020

    Quick measure gives you 2%

     

    Does not mean that its always correct in your specific scenario if you don't want 2% but 102% then you don't subtract.

    Theres no right and wrong here depends on what you need.