Forum Discussion
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 in...
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])
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])
You're a god.
