Sum Total by specific rows in Matrix

[krixtsup3r]

Hi Everyone!

Need some help with DAX formula wherein I have a matrix that would only sum a specific 'division'. See my screenshot below, 

I have totals per division and I only wanted the grand total to sum on specific division but it should still show the total per division

Thank you!

[wdx223_Daniel · Accepted solution]

Measure=IF(ISFILTERED(Table[Division]),SUM(Table[Amount]),CALCULATE(SUM(Table[Amount]),Table[Division] IN {"Corporate","Enterprise","Global","Product","Transformation"}))

[krixtsup3r]

it works perfectly!! Thank you!