Forum Discussion
Solved
adding an average measure to a chart with existing column variables
Hi, I have the following area chart visual, which contains a legend of two variables (CLO A and CLO B). I would like to calculate the average value of the CLO A and CLO B, and add that ...
Hi, MartynasBI
You can try the following methods.
Column:
Average = AVERAGEX(FILTER('Table',[Revenue growth]=EARLIER('Table'[Revenue growth])),[Nr of companies])Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kpost
Solution Sage
Solution SageIt would be a measure, not a column.
Unfortunately a measure in this case is not sufficient, as it cannot be added to the visual