title: How to solve Error Out of present Range in Power BI (DAX formula)
body: <p>I have tried to fix the out of present range problem in Power Bi Dax formula</p>
  
  <p><strong>General background</strong></p>
  
  <p>I have a data-set as below, the dashboard allows the user to select the preferred currency and then the table update the value. For example, if click on the US, then the table sum all Sales in Jan from the US</p>
  
  <p>as well as <strong>showing $ or €</strong> accordingly</p>
  
  <p><a href="https://i.stack.imgur.com/BUpkz.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BUpkz.gif" alt="enter image description here"></a></p>
  
  <p>The DAX function I have tried is </p>
  
  <pre><code>CONCATENATE( Table[Country]="US", "$",FORMAT(sum(Table[Sales]),"0")
  </code></pre>
  
  <p>but it comes up with below error</p>
  
  <blockquote>
    <h2>Couldn't load the data for this visual</h2>
    
    <p>The following system error occurred: Out of present range</p>
  </blockquote>
  
  <p>Any help, please. thanks</p>