Forum Discussion
Creating an average which does not change when filtering
Hi All, I'm still somewhat of a novice, but I am struggling with a measure which doesn't change when filtering. the average line needs to relate to months and years so I can create a visual which...
Hey,
can you please provide a simple example with some data, I'm not sure what you mean by regional.
Regards,
Tom
Hi Tom
Thanks for getting back to me here is the Link to Data
This includes the regions across EMEA so essentially the average line needs to keep referencing the entire region whilst being able to select a region (orange line on the original post) to see how its performing versus the regional average.
I hope that makes sense.