Matrix visual shows wrong total for string column

[akkibuddy7]

Why matrix visual shows total for string column ? It supposed to be blank.

incorrect total i have marked in Red color , any solution except changing background and font color ?

[akkibuddy7 · Accepted solution]

Found the solution - 
MeasureColumn = 
IF( HASONEVALUE(table[columnName]),

SELECTEDVALUE(table[columnName]),

Blank() )

Using above DAX Created 3 measure column for Code, Channel and date and it will show blank  in total row

[Deku]

This will also show a value in total if you filter down to a single item, using isinscope the total will remain blank in that edge case

[Deku]

If(Isinscope( table[name] ),[Code])

Will return code if filtered by code, will return blank for total

[akkibuddy7]

Tried the same logic for Code is regular column, its not allowing to use Code in second parameter in 'ISINSCOPE'

[Deku]

If you are using a implicit measure in the matrix for code, then you have to slightly update

If(Isinscope( table[name] ),selectedvalue(table[Code]))