Forum Discussion

Merleau's avatar
Merleau
Icon for Helper II rankHelper II
6 years ago

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 ...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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/547907

 

Also, 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

Merleau's avatar
Merleau
Icon for Helper II rankHelper II
6 years ago

Thank you Greg for the quick response.

I read the different links.

I will try to apply it but I am not sure how I can do that with my 20+ columns with text values that need a Total.

Thanks again

  • vishnu_51's avatar
    vishnu_51
    New Member
    3 years ago

    did you find the solution Merleau