Summarize Text Column in Table to show Total Rows but not Affect Individual Value

[Anonymous]

I have a table where one of the column is text.

I would like to show this on a table and then at the bottom of the column, I want to show total number of rows. To get the total number of rows, I can summarize the column and use COUNT. However, an undesired side effect is, the text values are now replaced with 1.

I am expecting this:

Name	Score
Ann	2
Bob	3
Cathy	5
Dartha	7
Eugene	11
Total      5	28

But getting this instead:

Name	Score
1	2
1	3
1	5
1	7
1	11
Total      5	28

I would like to keep the name values as is. 

[PaulDBrown]

@Anonymous 

As far as I'm aware, you cannot achieve the result as you are expecting. You can, however, create a measure along the lines of:

Name count = IF(ISINSCOPE(Table[name]), BLANK(), DISTINCTCOUNT(Table[name]))

which will deliver empty values on the name rows and the count on the "Total" Row.

not sure if that works for you, but thought it was worth mentioning.