Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Percentage Difference Quick Measure with Negative Values

Hi all,   I'm trying to calculate percentage difference between yesterday's margin and today's margin. Screenshot below of current quick measure (ignore red underline, changed table name for screen...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi,  Anonymous 

    It works well on my side.

    Please make sure [Yesterday’s Margin] and [Today’s Margin] are t actual columns or calculated columns in the table .

    If they are measures, it is recommended to convert them into calculated columns before you using  quick measure.

     

    If it doesn't work ,please share your sample file and expected result for further research.

     

    Best Regards,
    Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for your reply! Technically, I'm looking for it to return +170.5%, not negative.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous v-easonf-msft 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))

 

check my reply to post: https://community.powerbi.com/t5/Desktop/Quick-measure-Percentage-difference/m-p/204192