title: How do I ignore filters in AWS quicksight calculated measures?
body: <p>I have a SPICE dataset which holds our sales data with an analysis (&amp; subsequent dashboard) built on top of this.</p>
  
  <p>My stakeholder wants to be able to select a customer and review various metrics <em>alongside</em> the overall metrics. </p>
  
  <p>For example if I have a metric for "Average Commisison Rate" I'd want to put "Average Commission Rate - All Customers" in the same visualisation.</p>
  
  <p>I have tried the avgOver function but introducing the customer filters makes both metrics identical.</p>