title: How to filter existing measures created using DAX in Power BI?
body: <p>I have created two measures</p>
  <pre><code>#SavingsLocal = 
  
      CALCULATE(
          SUM('Savings'[sum(Risk Percentage*USLP Savings)]),
          FILTER(ALL('Savings'),SEARCH(&quot;NO&quot;,'Savings'[ICB],,BLANK()) &amp;&amp; SEARCH(&quot;YTD&quot;,'Savings'[Scenario],,BLANK())))
  </code></pre>
  <p>and</p>
  <pre><code>#SavingsGlobal = 
  CALCULATE(
      SUM('Savings'[sum(Risk Percentage*USLP Savings)]),
      FILTER(ALL('Savings'),SEARCH(&quot;YES&quot;,'Savings'[ICB],,BLANK()) &amp;&amp; SEARCH(&quot;YTD&quot;,'Savings'[Scenario],,BLANK())))
  </code></pre>
  <p>Now if my Region column present in the Savings Table is &quot;GLOBAL&quot;, I want to use my #SavingsGlobal else #SavingsLocal</p>
  <p>I created a calculated column for this</p>
  <pre><code>#finalsavings = IF(Savings[Location - Region (L1)] == &quot;GLOBAL&quot;,Savings[#SavingsGlobal],Savings[#SavingsLocal])
  </code></pre>
  <p>but this does not seem to work at all, its giving me a value for Global but for others I am getting a same value.</p>
  <p>How do I approach this using DAX?</p>