How to find SUMPRODUCT of two columns in DAX
<p>I am new to DAX formulas. I am looking to see how I can do an excel equivalent of a <code>SUMPRODUCT</code> for the following data:</p>

<pre><code>Id | Metric | Weight | Metric times Weight |  
1 | 20% | 30% | 6.0% 

2 | 10% | 20% | 2.0%  

3 | 25% | 20% | 5.0%  

4 | 12% | 10% | 1.2%  

5 | 15% | 10% | 1.5%  

6 | 2% | 10% | 0.2% |  | 


Net | 84.0% | 100.0% | 84.0% (expected Metric*Weight)
</code></pre>

<p>I need 15.9% which is <code>SUMPRODUCT(col1, col2)</code>.</p>

<p>The row total needs to be a <code>sumproduct()</code> versus the expected cross product above. </p>

<p>Any hints how I can achieve this?</p>