topic Summing values across rows using filter in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summing-values-across-rows-using-filter/m-p/2757813#M85343 <P>Dear community,</P><P>&nbsp;</P><P>image I have the following table</P><P>&nbsp;</P><P>Goal&nbsp;&nbsp; 2020 &nbsp; 2021 &nbsp; 2022</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 &nbsp; &nbsp; &nbsp;&nbsp; 30</P><P>B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 5 &nbsp; &nbsp; &nbsp;&nbsp; 10 &nbsp; &nbsp; &nbsp; 40</P><P>&nbsp;</P><P>I want to have to two meausures summing the values of A and B (MeausureA =60 and MeasureB = 55).</P><P>&nbsp;</P><P>How can I do this?</P><P>&nbsp;</P><P>Many thanks best regards</P> Fri, 09 Sep 2022 09:36:19 GMT Learner22 2022-09-09T09:36:19Z Summing values across rows using filter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summing-values-across-rows-using-filter/m-p/2757813#M85343 <P>Dear community,</P><P>&nbsp;</P><P>image I have the following table</P><P>&nbsp;</P><P>Goal&nbsp;&nbsp; 2020 &nbsp; 2021 &nbsp; 2022</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 &nbsp; &nbsp; &nbsp;&nbsp; 30</P><P>B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 5 &nbsp; &nbsp; &nbsp;&nbsp; 10 &nbsp; &nbsp; &nbsp; 40</P><P>&nbsp;</P><P>I want to have to two meausures summing the values of A and B (MeausureA =60 and MeasureB = 55).</P><P>&nbsp;</P><P>How can I do this?</P><P>&nbsp;</P><P>Many thanks best regards</P> Fri, 09 Sep 2022 09:36:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summing-values-across-rows-using-filter/m-p/2757813#M85343 Learner22 2022-09-09T09:36:19Z Re: Summing values across rows using filter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summing-values-across-rows-using-filter/m-p/2757945#M85354 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="392303" data-lia-user-login="Learner22" class="lia-mention lia-mention-user">Learner22</a> , if this is a data table, you need a measure and display that with the goal </P> <P>&nbsp;</P> <P>Sumx(Table, [2020], [2021], [2022])</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>You can unpivot the table , then you can simply sum the value part</P> <P><A href="https://radacad.com/pivot-and-unpivot-with-power-bi" target="_blank">https://radacad.com/pivot-and-unpivot-with-power-bi</A></P> Fri, 09 Sep 2022 10:22:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summing-values-across-rows-using-filter/m-p/2757945#M85354 amitchandak 2022-09-09T10:22:42Z