topic Re: How to sum numbers in the row as many as the numbers in a column in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3234110#M118775 <P>Hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>,</P><P>&nbsp;</P><P>Source data look like this picture</P><P><img /></P><P>&nbsp;</P> Sun, 14 May 2023 03:59:33 GMT LA_Enjoy 2023-05-14T03:59:33Z How to sum numbers in the row as many as the numbers in a column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3233912#M118761 <P>Hi my friends,</P><P>&nbsp;</P><P>Please help me,</P><P>I want to add column in tabel.</P><P>How to&nbsp;sum numbers in the row as many as the numbers in a column.</P><P>Here is the data sample and my expected result in last column.</P><P>I want to sum up item 1 until item 10&nbsp;as many as 8 in row 1</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Passage_item</TD><TD>Item 1</TD><TD>Item 2</TD><TD>Item 3</TD><TD>Item 4</TD><TD>Item 5</TD><TD>Item 6</TD><TD>Item 7</TD><TD>Item 8</TD><TD>Item 9</TD><TD>Item 10</TD><TD>Result</TD></TR><TR><TD>8</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>5</TD></TR><TR><TD>9</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>6</TD></TR><TR><TD>9</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>9</TD></TR><TR><TD>10</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>6</TD></TR><TR><TD>10</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>7</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks for Help</P> Sat, 13 May 2023 20:27:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3233912#M118761 LA_Enjoy 2023-05-13T20:27:53Z Re: How to sum numbers in the row as many as the numbers in a column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3233914#M118762 <P>I used this formula in excel</P><LI-CODE lang="markup">=SUMIF($B$1:$K$1;"&lt;="&amp;$A2;$B2:$K2)</LI-CODE> Sat, 13 May 2023 20:46:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3233914#M118762 LA_Enjoy 2023-05-13T20:46:42Z Re: How to sum numbers in the row as many as the numbers in a column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3233920#M118763 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="549132" data-lia-user-login="LA_Enjoy" class="lia-mention lia-mention-user">LA_Enjoy</a>&nbsp;</P> <P>how does the source data table look like?</P> Sat, 13 May 2023 21:00:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3233920#M118763 tamerj1 2023-05-13T21:00:35Z Re: How to sum numbers in the row as many as the numbers in a column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3234110#M118775 <P>Hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>,</P><P>&nbsp;</P><P>Source data look like this picture</P><P><img /></P><P>&nbsp;</P> Sun, 14 May 2023 03:59:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3234110#M118775 LA_Enjoy 2023-05-14T03:59:33Z Re: How to sum numbers in the row as many as the numbers in a column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3234267#M118804 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="549132" data-lia-user-login="LA_Enjoy" class="lia-mention lia-mention-user">LA_Enjoy</a>&nbsp;<BR />Please refer to attached sample file for all the details. The solution invoves many steps but all are simple.</P> <P><img /><img /><img /><img /><img /><img /><img /></P> Sun, 14 May 2023 12:55:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3234267#M118804 tamerj1 2023-05-14T12:55:10Z Re: How to sum numbers in the row as many as the numbers in a column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3234273#M118805 <P>Thanks man</P> Sun, 14 May 2023 13:11:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-numbers-in-the-row-as-many-as-the-numbers-in-a-column/m-p/3234273#M118805 LA_Enjoy 2023-05-14T13:11:59Z