title: A table of multiple values was supplied where a single value was expected
body: <p>I am trying to create KPI and for that i try to create a variable</p>
  <p>i have this formula</p>
  <pre><code>Total_Sales_Variable = 
  IF ( 
      VALUES (BillingDocument_Header[Billing Doc. currency_WAK] ) = &quot;USD&quot;,
      139.2,
      1
  ) * 
  CALCULATE ( 
      SUM (BillingDocument_Item[Sales Amount_NEWR]),
      FILTER ( 
          'Invoice_Calender',
          'Invoice_Calender'[Fiscal_Year] = 2016 &amp;&amp;
         'Invoice_Calender'[Fiscal_Year]  = 2017
      ),
      FILTER ( 
          'BillingDocument_Header',
          'BillingDocument_Header'[Bill Type_FKRT] &lt;&gt; &quot;Z2&quot; &amp;&amp;
          'BillingDocument_Header'[Bill Type_FKRT] &lt;&gt; &quot;Z2&quot;
      )
  )
  </code></pre>
  <p>when i add this shows an error</p>
  <p>MdxScript(Model) (8, 5) Calculation error in measure 'Invoice_Calender'[Total_Sales_Variable]: A table of multiple values was supplied where a single value was expected.</p>
  <p>and i am trying of achieve if Billing Doc. currency_WAk is USD then i want to sum of this field Sales Amount_NEWR against filters Fiscal_Year = {'2016','2017'} and [Billing Type_FKART] ={'ZG2','ZL2'}</p>
  <p>this is what i want to achieve in power bi i want to convert this into dax expression power bi
  qlik sense expression</p>
  <pre><code>    if([Billing Doc. currency_WAERK] = 'USD',
  sum({&lt; Fiscal_Year = {'2016','2017'},[Billing Type_FKART] -={'ZG2','ZL2'}&gt;}[Billing Sales Amount_NETWR])*139.2,
  sum({&lt; Fiscal_Year = {'2016','2017'},[Billing Type_FKART] -={'ZG2','ZL2'}&gt;}[Billing Sales Amount_NETWR]))
  </code></pre>
  <p>any help ?</p>
  <p><strong>UPDATE ATTACHED FILE</strong></p>
  <p>kindly check pbix file with data and tables</p>
  <p><a href="https://www.dropbox.com/s/flondhallo08j98/test4.pbix?dl=0" rel="nofollow noreferrer">https://www.dropbox.com/s/flondhallo08j98/test4.pbix?dl=0</a></p>