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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    There's an issue when the base value is negative and the compared value is positive. In general, if the numerator indicates the direction, i.e. increase or decrease, then the denominator must have the absolute value. I am getting around the error in quick measure formula by adding ABS(__BASELINE_VALUE). 

    --Thus changing

    RETURN
    DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE; __BASELINE_VALUE)

    --to

    RETURN
    DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE; ABS(__BASELINE_VALUE))

  • MHongisto's avatar
    MHongisto
    Frequent Visitor
    9 years ago

    Thank you! So it was an issue with me not understanding math or English.