Remove certain columns from Total row in Table visulisation

[matdune56]

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

[amitchandak]

Check this 

https://community.powerbi.com/t5/Desktop/Trying-to-turn-off-some-coumn-totals-in-a-plain-table-not-m...

[matdune56]

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 · Accepted solution]

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.

[matdune56]

sorry, I've been busy at work so only just got back to this.

How do I integrate your code (to create a new measure) with the code which I've written which creates my last comment measure(the field I'm trying to blank in the total row)

Measure = CALCULATE(MIN('osticket ost_thread_entry'[body]),FILTER('osticket ost_thread_entry','osticket ost_thread_entry'[created] = MAX('osticket ost_thread_entry'[created])))

do I place you code after this, or create a new measure and relate it back to the field above ?

thanks