https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-relative-to-two-metrics/m-p/2925026#M96049 <P>Hey&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="445601" data-lia-user-login="anna-lee" class="lia-mention lia-mention-user">anna-lee</a>&nbsp;,</P><P>You can use the code below:</P><LI-CODE lang="markup">SumValue = CALCULATE ( SUM ( Table[Value] ), ALLEXCEPT ( Table, Table[Vendor Code], Table[Year] ) )</LI-CODE><P>&nbsp;</P> Wed, 23 Nov 2022 16:43:50 GMT ERD 2022-11-23T16:43:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-relative-to-two-metrics/m-p/2924973#M96042 <P>Hi,</P><P>&nbsp;</P><P>I'm looking to sum the value of a table but still have it relative to the year and vendor code. Currently I can only get it relative to one column, but finding it difficult to do two. The result would be the column in blue below.</P><TABLE border="1"><TBODY><TR><TD>Vendor Code</TD><TD>Description</TD><TD>Concat</TD><TD>Year</TD><TD>Value</TD><TD><FONT color="#0000FF">Result</FONT></TD></TR><TR><TD>MA33C4</TD><TD>accountsreceivable</TD><TD>MA33C4accountsreceivable</TD><TD>2021</TD><TD>1774</TD><TD><FONT color="#0000FF">14194</FONT></TD></TR><TR><TD>MA33C4</TD><TD>accountsreceivable</TD><TD>MA33C4accountsreceivable</TD><TD>2020</TD><TD>1501</TD><TD><FONT color="#0000FF">13904</FONT></TD></TR><TR><TD>MA33C4</TD><TD>accountsreceivable</TD><TD>MA33C4accountsreceivable</TD><TD>2019</TD><TD>1103</TD><TD><FONT color="#0000FF">10484</FONT></TD></TR><TR><TD>MA33C4</TD><TD>accountsreceivable</TD><TD>MA33C4accountsreceivable</TD><TD>2018</TD><TD>4615</TD><TD><FONT color="#0000FF">20214</FONT></TD></TR><TR><TD>MA33C4</TD><TD>accountsreceivable</TD><TD>MA33C4accountsreceivable</TD><TD>2017</TD><TD>6852</TD><TD><FONT color="#0000FF">20017</FONT></TD></TR><TR><TD>MA33C4</TD><TD>accountsreceivable</TD><TD>MA33C4accountsreceivable</TD><TD>2016</TD><TD>1827</TD><TD><FONT color="#0000FF">10004</FONT></TD></TR><TR><TD>MA33C4</TD><TD>accountspayable</TD><TD>MA33C4accountspayable</TD><TD>2021</TD><TD>1094</TD><TD><FONT color="#0000FF">14194</FONT></TD></TR><TR><TD>MA33C4</TD><TD>accountspayable</TD><TD>MA33C4accountspayable</TD><TD>2020</TD><TD>1697</TD><TD><FONT color="#0000FF">13904</FONT></TD></TR><TR><TD>MA33C4</TD><TD>accountspayable</TD><TD>MA33C4accountspayable</TD><TD>2019</TD><TD>2144</TD><TD><FONT color="#0000FF">10484</FONT></TD></TR><TR><TD>MA33C4</TD><TD>accountspayable</TD><TD>MA33C4accountspayable</TD><TD>2018</TD><TD>3498</TD><TD><FONT color="#0000FF">20214</FONT></TD></TR><TR><TD>MA33C4</TD><TD>accountspayable</TD><TD>MA33C4accountspayable</TD><TD>2017</TD><TD>3624</TD><TD><FONT color="#0000FF">20017</FONT></TD></TR><TR><TD>MA33C4</TD><TD>accountspayable</TD><TD>MA33C4accountspayable</TD><TD>2016</TD><TD>1109</TD><TD><FONT color="#0000FF">10004</FONT></TD></TR><TR><TD>MA33C4</TD><TD>revenue</TD><TD>MA33C4revenue</TD><TD>2021</TD><TD>1480</TD><TD><FONT color="#0000FF">14194</FONT></TD></TR><TR><TD>MA33C4</TD><TD>revenue</TD><TD>MA33C4revenue</TD><TD>2020</TD><TD>1502</TD><TD><FONT color="#0000FF">13904</FONT></TD></TR><TR><TD>MA33C4</TD><TD>revenue</TD><TD>MA33C4revenue</TD><TD>2019</TD><TD>1002</TD><TD><FONT color="#0000FF">10484</FONT></TD></TR><TR><TD>MA33C4</TD><TD>revenue</TD><TD>MA33C4revenue</TD><TD>2018</TD><TD>7624</TD><TD><FONT color="#0000FF">20214</FONT></TD></TR><TR><TD>MA33C4</TD><TD>revenue</TD><TD>MA33C4revenue</TD><TD>2017</TD><TD>5489</TD><TD><FONT color="#0000FF">20017</FONT></TD></TR><TR><TD>MA33C4</TD><TD>revenue</TD><TD>MA33C4revenue</TD><TD>2016</TD><TD>4850</TD><TD><FONT color="#0000FF">10004</FONT></TD></TR><TR><TD>MA33C4</TD><TD>costofgoods</TD><TD>MA33C4costofgoods</TD><TD>2021</TD><TD>9846</TD><TD><FONT color="#0000FF">14194</FONT></TD></TR><TR><TD>MA33C4</TD><TD>costofgoods</TD><TD>MA33C4costofgoods</TD><TD>2020</TD><TD>9204</TD><TD><FONT color="#0000FF">13904</FONT></TD></TR><TR><TD>MA33C4</TD><TD>costofgoods</TD><TD>MA33C4costofgoods</TD><TD>2019</TD><TD>6235</TD><TD><FONT color="#0000FF">10484</FONT></TD></TR><TR><TD>MA33C4</TD><TD>costofgoods</TD><TD>MA33C4costofgoods</TD><TD>2018</TD><TD>4477</TD><TD><FONT color="#0000FF">20214</FONT></TD></TR><TR><TD>MA33C4</TD><TD>costofgoods</TD><TD>MA33C4costofgoods</TD><TD>2017</TD><TD>4052</TD><TD><FONT color="#0000FF">20017</FONT></TD></TR><TR><TD>MA33C4</TD><TD>costofgoods</TD><TD>MA33C4costofgoods</TD><TD>2016</TD><TD>2218</TD><TD><FONT color="#0000FF">10004</FONT></TD></TR><TR><TD>RQ020G</TD><TD>accountsreceivable</TD><TD>RQ020Gaccountsreceivable</TD><TD>2021</TD><TD>0</TD><TD><FONT color="#0000FF">0</FONT></TD></TR><TR><TD>RQ020G</TD><TD>accountsreceivable</TD><TD>RQ020Gaccountsreceivable</TD><TD>2020</TD><TD>1009</TD><TD><FONT color="#0000FF">11802</FONT></TD></TR><TR><TD>RQ020G</TD><TD>accountsreceivable</TD><TD>RQ020Gaccountsreceivable</TD><TD>2019</TD><TD>1903</TD><TD><FONT color="#0000FF">12597</FONT></TD></TR><TR><TD>RQ020G</TD><TD>accountsreceivable</TD><TD>RQ020Gaccountsreceivable</TD><TD>2018</TD><TD>1566</TD><TD><FONT color="#0000FF">11546</FONT></TD></TR><TR><TD>RQ020G</TD><TD>accountsreceivable</TD><TD>RQ020Gaccountsreceivable</TD><TD>2017</TD><TD>1083</TD><TD><FONT color="#0000FF">13891</FONT></TD></TR><TR><TD>RQ020G</TD><TD>accountsreceivable</TD><TD>RQ020Gaccountsreceivable</TD><TD>2016</TD><TD>0</TD><TD><FONT color="#0000FF">0</FONT></TD></TR><TR><TD>RQ020G</TD><TD>accountspayable</TD><TD>RQ020Gaccountspayable</TD><TD>2021</TD><TD>0</TD><TD><FONT color="#0000FF">0</FONT></TD></TR><TR><TD>RQ020G</TD><TD>accountspayable</TD><TD>RQ020Gaccountspayable</TD><TD>2020</TD><TD>4307</TD><TD><FONT color="#0000FF">11802</FONT></TD></TR><TR><TD>RQ020G</TD><TD>accountspayable</TD><TD>RQ020Gaccountspayable</TD><TD>2019</TD><TD>2743</TD><TD><FONT color="#0000FF">12597</FONT></TD></TR><TR><TD>RQ020G</TD><TD>accountspayable</TD><TD>RQ020Gaccountspayable</TD><TD>2018</TD><TD>2272</TD><TD><FONT color="#0000FF">11546</FONT></TD></TR><TR><TD>RQ020G</TD><TD>accountspayable</TD><TD>RQ020Gaccountspayable</TD><TD>2017</TD><TD>2397</TD><TD><FONT color="#0000FF">13891</FONT></TD></TR><TR><TD>RQ020G</TD><TD>accountspayable</TD><TD>RQ020Gaccountspayable</TD><TD>2016</TD><TD>0</TD><TD><FONT color="#0000FF">0</FONT></TD></TR><TR><TD>RQ020G</TD><TD>revenue</TD><TD>RQ020Grevenue</TD><TD>2021</TD><TD>0</TD><TD><FONT color="#0000FF">0</FONT></TD></TR><TR><TD>RQ020G</TD><TD>revenue</TD><TD>RQ020Grevenue</TD><TD>2020</TD><TD>3582</TD><TD><FONT color="#0000FF">11802</FONT></TD></TR><TR><TD>RQ020G</TD><TD>revenue</TD><TD>RQ020Grevenue</TD><TD>2019</TD><TD>4239</TD><TD><FONT color="#0000FF">12597</FONT></TD></TR><TR><TD>RQ020G</TD><TD>revenue</TD><TD>RQ020Grevenue</TD><TD>2018</TD><TD>4000</TD><TD><FONT color="#0000FF">11546</FONT></TD></TR><TR><TD>RQ020G</TD><TD>revenue</TD><TD>RQ020Grevenue</TD><TD>2017</TD><TD>5325</TD><TD><FONT color="#0000FF">13891</FONT></TD></TR><TR><TD>RQ020G</TD><TD>revenue</TD><TD>RQ020Grevenue</TD><TD>2016</TD><TD>0</TD><TD><FONT color="#0000FF">0</FONT></TD></TR><TR><TD>RQ020G</TD><TD>costofgoods</TD><TD>RQ020Gcostofgoods</TD><TD>2021</TD><TD>0</TD><TD><FONT color="#0000FF">0</FONT></TD></TR><TR><TD>RQ020G</TD><TD>costofgoods</TD><TD>RQ020Gcostofgoods</TD><TD>2020</TD><TD>2904</TD><TD><FONT color="#0000FF">11802</FONT></TD></TR><TR><TD>RQ020G</TD><TD>costofgoods</TD><TD>RQ020Gcostofgoods</TD><TD>2019</TD><TD>3712</TD><TD><FONT color="#0000FF">12597</FONT></TD></TR><TR><TD>RQ020G</TD><TD>costofgoods</TD><TD>RQ020Gcostofgoods</TD><TD>2018</TD><TD>3708</TD><TD><FONT color="#0000FF">11546</FONT></TD></TR><TR><TD>RQ020G</TD><TD>costofgoods</TD><TD>RQ020Gcostofgoods</TD><TD>2017</TD><TD>5086</TD><TD><FONT color="#0000FF">13891</FONT></TD></TR><TR><TD>RQ020G</TD><TD>costofgoods</TD><TD>RQ020Gcostofgoods</TD><TD>2016</TD><TD>0</TD><TD><FONT color="#0000FF">0</FONT></TD></TR></TBODY></TABLE> Wed, 23 Nov 2022 16:14:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-relative-to-two-metrics/m-p/2924973#M96042 anna-lee 2022-11-23T16:14:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-relative-to-two-metrics/m-p/2925026#M96049 <P>Hey&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="445601" data-lia-user-login="anna-lee" class="lia-mention lia-mention-user">anna-lee</a>&nbsp;,</P><P>You can use the code below:</P><LI-CODE lang="markup">SumValue = CALCULATE ( SUM ( Table[Value] ), ALLEXCEPT ( Table, Table[Vendor Code], Table[Year] ) )</LI-CODE><P>&nbsp;</P> Wed, 23 Nov 2022 16:43:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-relative-to-two-metrics/m-p/2925026#M96049 ERD 2022-11-23T16:43:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-relative-to-two-metrics/m-p/2925038#M96050 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="445601" data-lia-user-login="anna-lee" class="lia-mention lia-mention-user">anna-lee</a>&nbsp;<BR />Please try</P> <LI-CODE lang="javascript">Result = CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Vendor Code], 'Table'[Year] ) )</LI-CODE> Wed, 23 Nov 2022 16:46:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-relative-to-two-metrics/m-p/2925038#M96050 tamerj1 2022-11-23T16:46:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-relative-to-two-metrics/m-p/2933047#M96537 <P>thank you!</P> Mon, 28 Nov 2022 13:37:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-relative-to-two-metrics/m-p/2933047#M96537 anna-lee 2022-11-28T13:37:36Z