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 | YZ | YT | 3 | |
| 3 | YT | TT | 2 | ||
| Total | 2 | 1 | 3 | 2 | 8 |
Using option count just replaced the text with "1" but I would like the text to remain and have the total at the bottom. Can you somebody pls help?
Thanks
7 Replies
- Greg_Deckler
Community Champion
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907Also, this might help as well. https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-Roll/m-p/411443#M150
- vishnu_51New Member
hey Greg_Deckler,
I have a similar issue i referred the following links and could'nt come up with a solution. can you please help me regarding this.
- AltyNew Member
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.
- wdrain
Helper I
Was there ever a solution for this ?