Calculate the variance between two measured points.

[ollie2110]

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 5 variables. For example the column has factors 1,2,3,4,5. The data points on the above selected graph are the % share between factors 1 and 3. How would I go about this? I've tried with the quick measure function however I've had no luck. 

[Anonymous · Accepted solution]

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]

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. 

[Rupak_bi]

Plz share sample dataset