Removing Certain Total's, but keeping others

[Anonymous]

I want to keep the dollar total (second from the right) but remove the remaining totals. Is this possible?

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

You can also directly create a white rectangle to cover the total value you need to hide.

The result will show as below:

Please check the attached sample file for more details.

Best Regards,
Community Support Team _ Eason

[mahoneypat]

For the ones you want to remove, add HASONEVALUE into the mix.  For example,

NewMeasure = IF(HASONEVALUE(Table[Column]), [Your Measure])

Replace Table[Column] with one of the columns from your visual.  Since the total has multiple values, it will be false and return blank.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

HI @Anonymous 

Please remove the columns from the below location

[Anonymous]

@Anonymous 

I want to keep my data, but eliminate certain columns totals.. Only show the total for dollars but keep the other data..