topic Re: Remove Total from Column in a Table in DAX Commands and Tips

Remove Total from Column in a Table

madmanmark198 — Fri, 17 Jun 2022 08:34:20 GMT

Hi all

I have a table with a calculated measure where I am working out the number of days since a particular date in a column. Below is my DAX for it.

Days Open = DATEDIFF(MAX('Gift'[date]),TODAY(), DAY)

However when I use this measure in the table it totals it up in the column which I dont need so I wanted to find out if there was a way to hide or remove this from the totals row. I want to show the other totals so its just for this specific column " Days Open" only.

Re: Remove Total from Column in a Table

rohit_singh — Fri, 17 Jun 2022 08:37:37 GMT

Hi madmanmark198 ,

You can click on the visual, then navigate to the visualizations pane--> Totals --> Values --> Off

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

Re: Remove Total from Column in a Table

madmanmark198 — Fri, 17 Jun 2022 08:41:37 GMT

Thanks Rohit but this turns of the whole row of totals. I would still like to show the totals of a number of the other columns I have. So what I am looking for is the total for that specific column not to show. Do you know of a way?

Re: Remove Total from Column in a Table

rohit_singh — Fri, 17 Jun 2022 08:51:38 GMT

Hi madmanmark198 ,

You could try clicking on the dropdown icon in the column and selecting don't summarize. Maybe that helps?

Kind regards,

Rohit

Re: Remove Total from Column in a Table

madmanmark198 — Fri, 17 Jun 2022 08:58:19 GMT

I tried that but its not an option because its a calculate measure. All I get is the below:

Re: Remove Total from Column in a Table

Anonymous — Thu, 23 Jun 2022 06:02:02 GMT

Hi madmanmark198,

Measure expression cant be used as a category to expand records, so the 'do not summarize' option will not appear on this field 'right click' menu.

For your requirement, I'd like to suggest you add an if statement to your expression to check the current row context level to prevent the calculation on the total level.

Days Open = IF ( ISINSCOPE ( Table[Category] ), DATEDIFF ( MAX ( 'Gift'[date] ), TODAY (), DAY ) )

ISINSCOPE function (DAX) - DAX | Microsoft Docs

Regards,

Xiaoxin Sheng

Re: Remove Total from Column in a Table

PierreL69 — Tue, 13 May 2025 12:51:25 GMT

Thanks a lot very usefull !