Forum Discussion
Solved
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
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
