https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Can-t-achieve-SUM-within-group/m-p/3577672#M137965 <P>Hi,</P><P>&nbsp;</P><P>do you want it as a column or a measure?</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 11 Dec 2023 13:58:11 GMT lukiz84 2023-12-11T13:58:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Can-t-achieve-SUM-within-group/m-p/3577666#M137964 <P>I can't achieve the last column "Sum Of The Parent":</P><TABLE><TBODY><TR><TD>Parent</TD><TD>Client</TD><TD>Value</TD><TD>Sum Of The Parent</TD></TR><TR><TD>1</TD><TD>1</TD><TD>5</TD><TD>68</TD></TR><TR><TD>1</TD><TD>2</TD><TD>51</TD><TD>68</TD></TR><TR><TD>1</TD><TD>3</TD><TD>12</TD><TD>68</TD></TR><TR><TD>2</TD><TD>4</TD><TD>9480</TD><TD>29608</TD></TR><TR><TD>2</TD><TD>5</TD><TD>20000</TD><TD>29608</TD></TR><TR><TD>2</TD><TD>6</TD><TD>128</TD><TD>29608</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Like above... My goal is to display the SUM for where parent =1, for where parent =2 and so on...</P><P>&nbsp;</P><P>How can I achieve it in DAX?</P> Mon, 11 Dec 2023 13:56:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Can-t-achieve-SUM-within-group/m-p/3577666#M137964 Anonymous 2023-12-11T13:56:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Can-t-achieve-SUM-within-group/m-p/3577672#M137965 <P>Hi,</P><P>&nbsp;</P><P>do you want it as a column or a measure?</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 11 Dec 2023 13:58:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Can-t-achieve-SUM-within-group/m-p/3577672#M137965 lukiz84 2023-12-11T13:58:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Can-t-achieve-SUM-within-group/m-p/3577858#M137970 <P>It doesnt matter as long as I can display it in a table like the above...</P><P>&nbsp;</P><P>I think it has to be a column for it to work...</P> Mon, 11 Dec 2023 15:24:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Can-t-achieve-SUM-within-group/m-p/3577858#M137970 Anonymous 2023-12-11T15:24:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Can-t-achieve-SUM-within-group/m-p/3577949#M137974 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;<BR /><BR />Can you please try below DAX for measure</P><LI-CODE lang="markup">Measure = CALCULATE( SUM('Table'[Value]), ALLEXCEPT('Table','Table'[Parent]))</LI-CODE><P><BR /><FONT color="#0000FF"><STRONG>If solve the requirement, please mark this answer as a solution.</STRONG></FONT></P> Mon, 11 Dec 2023 15:56:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Can-t-achieve-SUM-within-group/m-p/3577949#M137974 PijushRoy 2023-12-11T15:56:22Z