The averages in the attached workbook change depending on what is filtered. I am trying to be able to have an average mark on the bar that doesn't change when filters are selected as well as a mark (bar in this instance) that does change when the filters are selected.
I basically want to be able to show how well an agent is doing against the average.
I think I've fixed it. I had to add the data source a second time and then add the same measure (albeit renamed for clarity) to the chart as a new mark. Everything works like I want it to (only certain filters change both data sources). Screenshot below:
Note that I've had to click the link symbol in the measures section only on measure that I want to change on both sources when filters are applied. Can't see a problem with it so far.