Invoke grand total

[Teodor_TRU]

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 · Accepted solution]

@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!

just FYI and reference

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

[Teodor_TRU]

You're a god.