Forum Discussion

Teodor_TRU's avatar
Teodor_TRU
Frequent Visitor
9 years ago
Solved

Invoke grand total

I am building a Burndown Chart, and my baseline looks like this : Baseline = 1046-[Cumulative Quantity]

1046 being the grand total of the COUNT of how many issues I have.

Is there any way in invoking my grand total dynamically ? I just want one number and not something that dynamically changes with my dates/rows.

 

If I look at a different project, I will have to manually change my grand total and would like to avoid that.

  • Sean's avatar
    Sean
    9 years ago

    Teodor_TRU

     

    Try either one of these

    First one counts ALL Rows in your table (including blanks)

     

    Grand Total = CALCULATE ( COUNTROWS ( TableName ), ALLSELETED ( TableName ) )

    OR

    the second counts all except blanks

     

    Grant Total = CALCULATE ( COUNTA ( TableName[Column] ), ALLSELECTED ( TableName ) )

    Take your pick according to your needs!

    Good Luck!:smileyhappy:

     

    just FYI and reference

    COUNTROWS(Table) = COUNTA(Table[Column]) + COUNTBLANK(Table[Column])

2 Replies

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    Teodor_TRU

     

    Try either one of these

    First one counts ALL Rows in your table (including blanks)

     

    Grand Total = CALCULATE ( COUNTROWS ( TableName ), ALLSELETED ( TableName ) )

    OR

    the second counts all except blanks

     

    Grant Total = CALCULATE ( COUNTA ( TableName[Column] ), ALLSELECTED ( TableName ) )

    Take your pick according to your needs!

    Good Luck!:smileyhappy:

     

    just FYI and reference

    COUNTROWS(Table) = COUNTA(Table[Column]) + COUNTBLANK(Table[Column])