Forum Discussion

user365576's avatar
user365576
Helper I
2 years ago
Solved

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 ...
Need Help
  • fahadqadir3's avatar
    fahadqadir3
    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!! 

fahadqadir3's avatar
fahadqadir3
Solution Supplier
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!!