Remove Total from a column

[user365576]

Hello,

I want to remove the total value from a specific column of a simple BI table.

I tried to remove the total from the format pane but it doesn't apply the changes to my column.

Any guesses how can it be resolved?

[fahadqadir3 · Accepted solution]

@user365576  Review the attached screenshot. you need to create a new measure and use isinscope function to remove Totals from a specific column.

Not Total = IF(ISINSCOPE('Table'[Attribute]), MAX('Table'[Date]),BLANK())

Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!! 

[cath1ynn]

Not sure that you can. What I've done in the past is just to set the text colour to white (if your table background is white) to hide it.

[user365576]

I tried it but that doesn't apply either