title: Multiply measure by column without aggregating the latter
body: <p>I have the below dataset and user country as a filter. The task is to calculate the revenue - calculated as cum sum paid in this month - cum sum paid in the previous month. It should be calculated in USD. The solution of multiplying the exchange rate in the below table, then, creating a measure using PREVIOUSMONTH and then, doing subtraction doesn't work because of the high exchange rate fluctuation. </p>
  
  <p><a href="https://i.stack.imgur.com/rZpDY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rZpDY.png" alt="enter image description here"></a></p>
  
  <p>The solution we came with was to calculate the revenue in the local currency. And then, if a user selects Switzerland from the filter, the revenue will be multiplied by the exchange rate for the corresponding country and corresponding date. </p>
  
  <p><a href="https://i.stack.imgur.com/4h13a.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4h13a.png" alt="enter image description here"></a></p>
  
  <p>Here are the formulas in practice. My issue is that I cannot find a way to multiply by the actual exchange rate as I need to aggregate exchange rate somehow and I am currently multiplying by averagex.</p>
  
  <p>Measures:</p>
  
  <pre><code>prior_month_sum_lc = CALCULATE(sum(fact_payment[sum_paid_to_date]),PREVIOUSMONTH(calendar_3[Date]))
   
  revenue = sum(fact_payment[sum_paid_to_date])-[prior_month_sum_lc] 
   
  revenue_used = IF(SELECTEDVALUE(fact_payment[country])="Spain",
  [revenue] * AVERAGEX(fact_payment,fact_payment[xr_es]),0 )
  </code></pre>
  
  <p>Calculation done manually
  <a href="https://i.stack.imgur.com/21bx7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/21bx7.png" alt="enter image description here"></a></p>