Forum Discussion
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 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.
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.
3 Replies
- Rupak_bi
Super User
Plz share sample dataset
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.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.
