Forum Discussion
Total string column in table report
Hello, I have more than 15 columns in my "table" reoprt with text values and I would like the "Total" row to show their sum. As this: ID XY YZ YT TT Count 1 XY YT TT 3 2 XY ...
you may try this
Measure = if(HASONEVALUE('table'[col]),max('table'[col]),count('table'[col]))
max of column with one value will return the col value itself and for totals, it will show count. Hope this helps.