Forum Discussion
Summarize Text Column in Table to show Total Rows but not Affect Individual Value
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.
1 Reply
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.
