https://community.fabric.microsoft.com/t5/Developer/Dax-Expression/m-p/2898313#M39686 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/459751">@22LACMT</a>&nbsp;Try:</P> <LI-CODE lang="markup">= SUMX('Table',[field X] * [field Y])/ SUM([field X)</LI-CODE> Thu, 10 Nov 2022 18:40:41 GMT Greg_Deckler 2022-11-10T18:40:41Z https://community.fabric.microsoft.com/t5/Developer/Dax-Expression/m-p/2898187#M39683 <P>how do I write this as a Dax expression?&nbsp;</P><P>&nbsp;</P><P>&nbsp; =sum(field X * field Y)/sum(Field X)</P><P>&nbsp;</P><P>I get an error that the sum function in only expecting one field.&nbsp;</P> Thu, 10 Nov 2022 18:33:10 GMT https://community.fabric.microsoft.com/t5/Developer/Dax-Expression/m-p/2898187#M39683 22LACMT 2022-11-10T18:33:10Z https://community.fabric.microsoft.com/t5/Developer/Dax-Expression/m-p/2898313#M39686 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/459751">@22LACMT</a>&nbsp;Try:</P> <LI-CODE lang="markup">= SUMX('Table',[field X] * [field Y])/ SUM([field X)</LI-CODE> Thu, 10 Nov 2022 18:40:41 GMT https://community.fabric.microsoft.com/t5/Developer/Dax-Expression/m-p/2898313#M39686 Greg_Deckler 2022-11-10T18:40:41Z https://community.fabric.microsoft.com/t5/Developer/Dax-Expression/m-p/2906956#M39753 <P>Sorry, it its still giving me errors . I added a filter but am still getting incorrect data</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="22LACMT_0-1668525724628.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/823434iBBFD56B8AA5D5CD3/image-size/medium?v=v2&amp;px=400" role="button" title="22LACMT_0-1668525724628.png" alt="22LACMT_0-1668525724628.png" /></span></P><P>&nbsp;</P> Tue, 15 Nov 2022 15:22:25 GMT https://community.fabric.microsoft.com/t5/Developer/Dax-Expression/m-p/2906956#M39753 22LACMT 2022-11-15T15:22:25Z