Forum Discussion

akkibuddy7's avatar
akkibuddy7
Helper I
1 year ago
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 ?  
Need Help
  • akkibuddy7's avatar
    akkibuddy7
    1 year ago

    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's avatar
Deku
Super User
1 year ago

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

 

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

  • akkibuddy7's avatar
    akkibuddy7
    Helper I
    1 year ago

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

     

    • Deku's avatar
      Deku
      Super User
      1 year ago

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