Forum Discussion
user365576
Helper I
2 years agoRemove 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 ...
- 2 years ago
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
Resolver II
2 years agoNot 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.
- user3655762 years ago
Helper I
I tried it but that doesn't apply either