https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Custom-Matrix/m-p/2663214#M4747 <P>In excel there is the ability to sum columns but average by row. How do I achieve this in a Matrix?<img /></P> Tue, 26 Jul 2022 21:01:52 GMT shoeshirt 2022-07-26T21:01:52Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Custom-Matrix/m-p/2663214#M4747 <P>In excel there is the ability to sum columns but average by row. How do I achieve this in a Matrix?<img /></P> Tue, 26 Jul 2022 21:01:52 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Custom-Matrix/m-p/2663214#M4747 shoeshirt 2022-07-26T21:01:52Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Custom-Matrix/m-p/2670787#M4766 <P>You create a measure and use HASONEVALUE() to figure out where in the matrix you are (cell, row total, column total, or grand total)&nbsp; and calculate the measure accordingly.</P> Sat, 30 Jul 2022 19:31:49 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Custom-Matrix/m-p/2670787#M4766 lbendlin 2022-07-30T19:31:49Z