Forum Discussion
Sum Total by specific rows in Matrix
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!
Measure=IF(ISFILTERED(Table[Division]),SUM(Table[Amount]),CALCULATE(SUM(Table[Amount]),Table[Division] IN {"Corporate","Enterprise","Global","Product","Transformation"}))
2 Replies
- wdx223_Daniel
Community Champion
Measure=IF(ISFILTERED(Table[Division]),SUM(Table[Amount]),CALCULATE(SUM(Table[Amount]),Table[Division] IN {"Corporate","Enterprise","Global","Product","Transformation"}))