Forum Discussion
Remove Total from a column
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?
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!!
3 Replies
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.
I tried it but that doesn't apply either
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!!
