topic Re: Total string column in table report in DAX Commands and Tips

Total string column in table report

Merleau — Wed, 19 Feb 2020 14:30:54 GMT

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:

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

Greg_Deckler — Wed, 19 Feb 2020 15:26:36 GMT

Merleau — Wed, 19 Feb 2020 18:17:08 GMT

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 — Thu, 08 Dec 2022 07:08:55 GMT

did you find the solution Merleau

vishnu_51 — Thu, 08 Dec 2022 07:11:20 GMT

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.

Alty — Thu, 10 Aug 2023 15:23:56 GMT

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 — Sun, 28 Jan 2024 01:00:11 GMT

Was there ever a solution for this ?

talespin — Mon, 29 Jan 2024 06:17:06 GMT

At present only way I can think of is by creating measure for each column.

Measure for column TT =

IF( HASONEFILTER(TestTable3[TT]) , SELECTEDVALUE(TestTable3[TT]), SUMX(TestTable3, IF( ISBLANK(TestTable3[TT]) || TestTable3[TT] = "", 0 , 1)))