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 ...
talespin's avatar
talespin
Icon for Solution Sage rankSolution Sage
2 years ago

Hi Merleau ,

 

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)))