Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 tota...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

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

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    it works perfectly!! Thank you!