https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-Calculated-Custom-Rows-in-Matrix-Visual/m-p/1709184#M35274 <P>Hi !<BR />My Data Link:-<A href="https://www.dropbox.com/s/po1bu897ml8h800/Custom%20Calculated%20Rows.pbix?dl=0" target="_blank">https://www.dropbox.com/s/po1bu897ml8h800/Custom%20Calculated%20Rows.pbix?dl=0</A><BR />I want to add Calculated Custom Rows in Matrix Visual.<BR />This is my Matrix Visual and at the end of Brands for both category I want to add two custom rows.<BR />One will have Core Brands(That will comprise of few selected Brands)<BR />The Other will have Others(e.g. 100000-sum(all brands).<BR /><BR /><img /></P><P>&nbsp;</P><P>How I want it to be:-<BR />(This brands are selected randomly for e.g purpose)<BR /><img /></P><P>Thanks in advance.</P> Mon, 08 Mar 2021 14:30:32 GMT souvik900766 2021-03-08T14:30:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-Calculated-Custom-Rows-in-Matrix-Visual/m-p/1709184#M35274 <P>Hi !<BR />My Data Link:-<A href="https://www.dropbox.com/s/po1bu897ml8h800/Custom%20Calculated%20Rows.pbix?dl=0" target="_blank">https://www.dropbox.com/s/po1bu897ml8h800/Custom%20Calculated%20Rows.pbix?dl=0</A><BR />I want to add Calculated Custom Rows in Matrix Visual.<BR />This is my Matrix Visual and at the end of Brands for both category I want to add two custom rows.<BR />One will have Core Brands(That will comprise of few selected Brands)<BR />The Other will have Others(e.g. 100000-sum(all brands).<BR /><BR /><img /></P><P>&nbsp;</P><P>How I want it to be:-<BR />(This brands are selected randomly for e.g purpose)<BR /><img /></P><P>Thanks in advance.</P> Mon, 08 Mar 2021 14:30:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-Calculated-Custom-Rows-in-Matrix-Visual/m-p/1709184#M35274 souvik900766 2021-03-08T14:30:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-Calculated-Custom-Rows-in-Matrix-Visual/m-p/1819883#M38592 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="218999" data-lia-user-login="souvik900766" class="lia-mention lia-mention-user">souvik900766</a>,</P> <P>&nbsp;</P> <P>You can create a grouping table like the one below, and add the Grouping column to the matrix.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>The link in your post no longer works.</P> Mon, 03 May 2021 13:01:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-Calculated-Custom-Rows-in-Matrix-Visual/m-p/1819883#M38592 DataInsights 2021-05-03T13:01:15Z