Forum Discussion

ollie2110's avatar
ollie2110
Frequent Visitor
2 years ago
Solved

Calculate the variance between two measured points.

I have the graph pictured above. I want to display the variance % between the data points. The data points above have been calculated as the % share between two variables in a column that has...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ollie2110 

     

    1. Create a measure for Variance % with the following DAX:

    ([Restrictive Booking %] is the measure you are currently using in your chart)

    Variance % = 
VAR CurrentValue = [Restrictive Booking %]
VAR PreviousValue = CALCULATE([Restrictive Booking %], PREVIOUSMONTH('Table'[YearMonth]))
RETURN
IF(NOT ISBLANK(PreviousValue), DIVIDE(CurrentValue - PreviousValue, PreviousValue, 0) * 100, BLANK())

     2. Use Variance % as “Tooltips” for your chart visual.

     

    Best Regards,
    Jarvis Tang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ollie2110 

 

1. Create a measure for Variance % with the following DAX:

([Restrictive Booking %] is the measure you are currently using in your chart)

Variance % = 
VAR CurrentValue = [Restrictive Booking %]
VAR PreviousValue = CALCULATE([Restrictive Booking %], PREVIOUSMONTH('Table'[YearMonth]))
RETURN
IF(NOT ISBLANK(PreviousValue), DIVIDE(CurrentValue - PreviousValue, PreviousValue, 0) * 100, BLANK())

 2. Use Variance % as “Tooltips” for your chart visual.

 

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • ollie2110's avatar
    ollie2110
    Frequent Visitor
    2 years ago

    Hi Anonymous , 

     

    So I decided to use the Month-on-month Quick measure which seemed to work well. Its an issue of displaying the variance as opposed to calculating it. I Would like to display the variance % in the red-lined areas as opposed to the secondary dark blue line.