https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Matrix-Rounding-the-total/m-p/3563496#M137367 <P>It's possible with a combination of ISINSCOPE, ROUND, and SUMX but seems like a really bad idea to me as it leads to totals that are not accurate, espescially if you have a bunch of categories and they happen to mostly get rounded up or mostly rounded down.</P> Fri, 01 Dec 2023 16:59:32 GMT AlexisOlson 2023-12-01T16:59:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Matrix-Rounding-the-total/m-p/3563349#M137359 <P>Matrix Table 1:</P><P><img /></P><P>&nbsp;</P><P><SPAN>I have a matrix table similar as above and i want achive effect like in column "effect to be achieved"<BR />I need use mesure to this<BR /><BR /><BR /></SPAN></P> Fri, 01 Dec 2023 15:23:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Matrix-Rounding-the-total/m-p/3563349#M137359 AdamPolak96 2023-12-01T15:23:03Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Matrix-Rounding-the-total/m-p/3563496#M137367 <P>It's possible with a combination of ISINSCOPE, ROUND, and SUMX but seems like a really bad idea to me as it leads to totals that are not accurate, espescially if you have a bunch of categories and they happen to mostly get rounded up or mostly rounded down.</P> Fri, 01 Dec 2023 16:59:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Matrix-Rounding-the-total/m-p/3563496#M137367 AlexisOlson 2023-12-01T16:59:32Z