Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Remove certain columns from Total row in Table visulisation

Hi

 

is it possible to remove specific columns from a total row in a table visualisation. Obviously numeric fields make sense, but there's no point in displaying a "Summed" value for a text field (it seems to use the last one in the table) - like a comment.

 

thanks

Need Help
  • dax's avatar
    dax
    6 years ago

    Hi matdune56,

    You said that you want to hide some column in Total of Table, right? So did you mean that you want to show blank in Total for saome columns? If so, you could try above link measure like below(create a new measure to use your original meausre)

    Measure 10 = if(HASONEVALUE(t5[date]),[Measure 6], BLANK())

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      thanks, but need a little more help

       

      the column I don't want displayed is a caclulated measure, which gets the last comment in a support ticket thread. I currently have the following code

       

      Measure = CALCULATE(MIN('osticket ost_thread_entry'[body]),FILTER('osticket ost_thread_entry','osticket ost_thread_entry'[created] = MAX('osticket ost_thread_entry'[created])))
       
      How would I use the code in the linked solution, would i have to add that to the measure above ? I'm not clear how that blanks out the field in the total row ?
       
      thanks again
      • dax's avatar
        dax
        Community Support
        6 years ago

        Hi matdune56,

        You said that you want to hide some column in Total of Table, right? So did you mean that you want to show blank in Total for saome columns? If so, you could try above link measure like below(create a new measure to use your original meausre)

        Measure 10 = if(HASONEVALUE(t5[date]),[Measure 6], BLANK())

        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.