https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Total-by-specific-rows-in-Matrix/m-p/3129616#M111284 <P>Measure=IF(ISFILTERED(Table[Division]),SUM(Table[Amount]),CALCULATE(SUM(Table[Amount]),Table[Division] IN {"Corporate","Enterprise","Global","Product","Transformation"}))</P> Tue, 14 Mar 2023 02:40:45 GMT wdx223_Daniel 2023-03-14T02:40:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Total-by-specific-rows-in-Matrix/m-p/3129473#M111280 <P>Hi Everyone!</P><P>Need some help with DAX formula wherein I have a matrix that would only sum a specific 'division'. See my screenshot below,&nbsp;</P><P>I have totals per division and I only wanted the <U>grand total to sum on specific</U> division <U>but it should still show the total per division</U></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P><STRONG>Thank you!</STRONG></P><P>&nbsp;</P> Tue, 14 Mar 2023 01:41:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Total-by-specific-rows-in-Matrix/m-p/3129473#M111280 Anonymous 2023-03-14T01:41:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Total-by-specific-rows-in-Matrix/m-p/3129616#M111284 <P>Measure=IF(ISFILTERED(Table[Division]),SUM(Table[Amount]),CALCULATE(SUM(Table[Amount]),Table[Division] IN {"Corporate","Enterprise","Global","Product","Transformation"}))</P> Tue, 14 Mar 2023 02:40:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Total-by-specific-rows-in-Matrix/m-p/3129616#M111284 wdx223_Daniel 2023-03-14T02:40:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Total-by-specific-rows-in-Matrix/m-p/3129629#M111287 <P>it works perfectly!! Thank you!</P> Tue, 14 Mar 2023 02:50:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Total-by-specific-rows-in-Matrix/m-p/3129629#M111287 Anonymous 2023-03-14T02:50:12Z