https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-values-per-parameter/m-p/2545983#M71919 <P>Anonymous</LI-USER>&nbsp;<BR /><BR />Please use the following measure&nbsp;<BR /><BR /></P> <LI-CODE lang="markup">M = CALCULATE ( SUM( Table[Value]), ALLEXCEPT ( table , table[person id]) )</LI-CODE> <P><BR /><BR /><BR /></P> Sun, 29 May 2022 12:55:47 GMT Fowmy 2022-05-29T12:55:47Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-values-per-parameter/m-p/2545974#M71917 <P>Hi! I have a table:&nbsp;</P><TABLE border="1"><TBODY><TR><TD>person_id</TD><TD>value</TD></TR><TR><TD>1022</TD><TD>0</TD></TR><TR><TD>1022</TD><TD>0</TD></TR><TR><TD>1022</TD><TD>0</TD></TR><TR><TD>1022</TD><TD>1</TD></TR><TR><TD>1022</TD><TD>0</TD></TR></TBODY></TABLE><P>And so on, so it is a column, where we have 5 values per one person, I need a column that will show the sum of those 5 values per person, so it will look like this:</P><TABLE border="1"><TBODY><TR><TD>person_id</TD><TD>value</TD><TD>sum</TD></TR><TR><TD>1022</TD><TD>0</TD><TD>1</TD></TR><TR><TD>1022</TD><TD>0</TD><TD>1</TD></TR><TR><TD>1022</TD><TD>0</TD><TD>1</TD></TR><TR><TD>1022</TD><TD>1</TD><TD>1</TD></TR><TR><TD>1022</TD><TD>0</TD><TD>1</TD></TR></TBODY></TABLE><P>What dax formula I need to create a column "sum"</P> Sun, 29 May 2022 12:47:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-values-per-parameter/m-p/2545974#M71917 Anonymous 2022-05-29T12:47:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-values-per-parameter/m-p/2545983#M71919 <P>Anonymous</LI-USER>&nbsp;<BR /><BR />Please use the following measure&nbsp;<BR /><BR /></P> <LI-CODE lang="markup">M = CALCULATE ( SUM( Table[Value]), ALLEXCEPT ( table , table[person id]) )</LI-CODE> <P><BR /><BR /><BR /></P> Sun, 29 May 2022 12:55:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-values-per-parameter/m-p/2545983#M71919 Fowmy 2022-05-29T12:55:47Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-values-per-parameter/m-p/2545986#M71920 <P>Hi,</P> <P>Please try the below to create a new column.</P> <P>&nbsp;</P> <LI-CODE lang="markup">Sum CC = SUMX ( FILTER ( 'TableName', 'TableName'[person_id] = EARLIER ( 'TableName'[person_id] ) ), 'TableName'[value] ) </LI-CODE> Sun, 29 May 2022 12:57:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-values-per-parameter/m-p/2545986#M71920 Jihwan_Kim 2022-05-29T12:57:33Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-values-per-parameter/m-p/2545988#M71921 <P>Is this to be a measure or a calculated column? If a calc column...</P><LI-CODE lang="csharp">[Sum] = // calc column var vPerson = T[person_id] var Result = SUMX( filter( T, T[person_id] = vPerson ), T[value] ) RETURN Result</LI-CODE> Sun, 29 May 2022 12:58:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-values-per-parameter/m-p/2545988#M71921 daXtreme 2022-05-29T12:58:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-values-per-parameter/m-p/2545989#M71922 <P>Thanks a lot</P> Sun, 29 May 2022 12:58:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-values-per-parameter/m-p/2545989#M71922 Anonymous 2022-05-29T12:58:56Z