https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-total-on-all-rows-with-DAX/m-p/2449609#M65875 <P>Anonymous</LI-USER> , </P> <P>&nbsp;</P> <P>Total = calculate(sum(Table[Value]), allselected())</P> Mon, 11 Apr 2022 12:31:21 GMT amitchandak 2022-04-11T12:31:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-total-on-all-rows-with-DAX/m-p/2449462#M65868 <P>Hi there,</P><P>&nbsp;</P><P>For our case we need to have a DAX measure that shows the total of a value on all rows. This needs to in dynamically so we figured that DAX should be needed.</P><P>&nbsp;</P><P>Here is an example:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>&nbsp;</TD><TD>Value</TD><TD>Total</TD></TR><TR><TD>a</TD><TD>1</TD><TD>11 <SPAN>--&gt; SUM(A:C)</SPAN></TD></TR><TR><TD>b</TD><TD>4</TD><TD>11</TD></TR><TR><TD>c</TD><TD>6</TD><TD>11</TD></TR><TR><TD><STRONG>TOTAL</STRONG></TD><TD>11</TD><TD>33</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Does anyone know the DAX measure for this?</P><P>&nbsp;</P><P>Thanks!</P> Mon, 11 Apr 2022 11:37:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-total-on-all-rows-with-DAX/m-p/2449462#M65868 Anonymous 2022-04-11T11:37:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-total-on-all-rows-with-DAX/m-p/2449609#M65875 <P>Anonymous</LI-USER> , </P> <P>&nbsp;</P> <P>Total = calculate(sum(Table[Value]), allselected())</P> Mon, 11 Apr 2022 12:31:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-total-on-all-rows-with-DAX/m-p/2449609#M65875 amitchandak 2022-04-11T12:31:21Z