https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Aggregate-Rows/m-p/1506423#M29210 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="267453" data-lia-user-login="sekinod" class="lia-mention lia-mention-user">sekinod</a> , A measure</P> <P>Total Sales&nbsp; = sum(Table[sales])&nbsp; In visual with customer</P> <P>or when drag sales in field you can choose aggregation as sum</P> <P>&nbsp;</P> <P>Or new table in dax</P> <P>table = summarize(Table, Table[customer]) , "Sales",sum(Table[sales]) )</P> Fri, 20 Nov 2020 06:00:40 GMT amitchandak 2020-11-20T06:00:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Aggregate-Rows/m-p/1506370#M29209 <P>Let's assume I have a table as below</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>And I want aggregate row as below<BR /><BR /></P><P><img /></P><P>&nbsp;</P><P>How can&nbsp; I do that, thanks</P> Fri, 20 Nov 2020 05:34:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Aggregate-Rows/m-p/1506370#M29209 sekinod 2020-11-20T05:34:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Aggregate-Rows/m-p/1506423#M29210 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="267453" data-lia-user-login="sekinod" class="lia-mention lia-mention-user">sekinod</a> , A measure</P> <P>Total Sales&nbsp; = sum(Table[sales])&nbsp; In visual with customer</P> <P>or when drag sales in field you can choose aggregation as sum</P> <P>&nbsp;</P> <P>Or new table in dax</P> <P>table = summarize(Table, Table[customer]) , "Sales",sum(Table[sales]) )</P> Fri, 20 Nov 2020 06:00:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Aggregate-Rows/m-p/1506423#M29210 amitchandak 2020-11-20T06:00:40Z