Forum Discussion
Matrix visual shows wrong total for string column
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 ?
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
5 Replies
If(Isinscope( table[name] ),[Code])
Will return code if filtered by code, will return blank for total
Tried the same logic for Code is regular column, its not allowing to use Code in second parameter in 'ISINSCOPE'
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]))
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
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
