Forum Discussion
user365576
2 years agoHelper I
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 ...
- 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
2 years agoResolver II
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
2 years agoHelper I
I tried it but that doesn't apply either